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

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

[mbarakomar]

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

[sazisomnyandu]

Finally I have found a very useful video

Thank you

[monsterx]

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

[abhijeetbhagat]

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

[ahmadaimanbindahakimstaff]

hi there.. thank you for the tutorial.. your guide is very is useful.. tq

[NitishKumar-gocy]

Well defined. Very helpful. Keep uploading these kind of more helpful videos.

[naveedjunejo]

Thanks for posting, it really help me alot. thanks again

[GhaiAbuya-ohgd]

this has been very useful to me, thank you so much

[sitapathiraokotagiri]

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

[bateyboo]

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

[ayeminthant]

it really work for me for ranging less than and greater than Gross tonnage calculation. thank you so much

[hvsuixi]

at least, i have found this capabilities of Excel!!!

[letstravelarounduganda]

I literally did my class assignment with the help of this tutorial and finally got it right .., thank you !!

[ginapyzalski]

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.

[deeptikarki]

Thankyou sooo much 🎉 after repeated mistakes now I properly understood about nested if just in your one video. It was damn helpfull. 😊

[tolga.b.]

That this video saves minutes is absolute

[quentinfourie]

Awesome presentation of the IF function. How could place all the same test scores ((e.g., 4.0, 5.0, 6.0, 7, 0 ...) from your table into another table column with these same values. e.g. Column K=4.0, L=4.5, M=5.0, But still, maintain the name order for all the scores on the left-most column? Thanks!

[asifsaleem]

Great... Thank you so much... its really very easy....

[vqipdig]

Finally find something
What i need actually
❤❤❤❤❤

[prashanthn]

It was indeed very useful and informative