IF Function with 4 Criteria in Excel | IF Formula with many Conditions

Рет қаралды 225,246

11 ай бұрын

IF Function with 4 Criteria in Excel | IF Formula with many Conditions
In this Excel video tutorial, we gonna see how to do an if function in Excel with 4 different conditions. In this Excel tutorial, let's see how to use the if function with multiple criteria in Excel.
If you already know how to use the IF function with 3 conditions, I believe you will be able to learn the logical process of this formula, function, in Excel much easier.
To make the se function with four different criteria we will need to nest the functions, that is, we will have to learn how to put one IF function inside the other. Basically, it's a how to join formulas and functions in Excel, and it's called Nested Function or Nested Formula.
The IF function is one of the most important functions in Excel because it's can help us to automate tasks.
This is an Excel tutorial, it is an advanced example of using the if function. Here, we will learn step by step how to make use of the if function until we apply the 4 if conditionals.
#JopaExcel #Dashboard #Excel

Пікірлер: 80

@iqrazonecommerce6126

500000 monthly sales. Give the excel formula to convert this amount into 30 days. Do not repeat the amount

@valmir144

everybody teaches exactly the same thing. no one can teach how to get two returns? Damn!

@sitapathiraokotagiri8803 Күн бұрын

Sir please the software you used to draw coloured boxes and arrows,pls again.

@davidspear9790

The IFS function is much simpler when working with multiple values.

@hussinali8858

Hi, how to create a formulae, eg: if in Column A1 is <1 therefore in Column B1 and C1, 20 * 6 = 120, however if in Column A1 is >1, therefore the Answer shall be the same as shown in it.

@rahmakabeel661

I tried it but it only outputs the first if and the last else it doesn’t consider the other if conditions I don’t know why

@anthonybuda3807

What did you press to lock K2 cell sir?

@ahmadaimanbindahakimstaff2510

HI, IT IS OK IF THE LAST CRITERIA WE ALSO MAKE IT IN THE NEST?

@fidesybanez7510

What if the value is the other way around? For example, I want to change the letter grade to a number. It's when I calculate for GPA. Let's say A=4, B=3, C=2 and D=1. I have letter grades (alpha, not numeric) that I need to change to numbers. How do I do that?

@johnaxta1008

Definitely gets the job done but Is there a reason why you didn't use the =IFS() function which can have multiple criteria and should have the same result but easier?

@mbarakomar5805 28 күн бұрын

Thanx, i was looking for this example for long time. Finally i got it 💯👌

@sazisomnyandu9546

Finally I have found a very useful video

@abhijeetbhagat100

thank you so much, finally i found your video is useful

@monsterx6757

I like your explanations. I went for classroom based course but you make it clear for me after all the confusions.

@bateyboo1

This is great, thank you. But how do I get this to work but going across a row, rather than copying formula down column? I have rows of data and I want to apply the conditional formatting on each cell in the row, how can I do this without having to have an IF formula for every cell in row? Thank you

@ginapyzalski127

Thank you so much for this video! I am using this in an educational setting where the score is equal to a specific classification. I am so tired of having to check the grid EVERY time I write a report and I need to classify 40 scores on a single report! "If you know (about score reports) you know" This is going to save me until I retire! Wish I had it 25 years ago.