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

Рет қаралды 206,695

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

Пікірлер: 79

@user-ve4kb8bl4s 8 ай бұрын

Clearly defined. Thanks.

@ayeminthant2372 7 ай бұрын

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

@noonk7828 5 ай бұрын

It's a really good explanation.thank you so much

@monsterx6757 4 ай бұрын

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

@mbarakomar5805 8 күн бұрын

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

@sazisomnyandu9546 Ай бұрын

Finally I have found a very useful video Thank you

@GhaiAbuya-oh8gd 3 ай бұрын

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

@NitishKumar-go6cy 2 ай бұрын

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

@user-vq3ip1di7g 8 ай бұрын

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

@prashanthn5819 5 ай бұрын

It was indeed very useful and informative

@letstravelarounduganda1252 8 ай бұрын

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

@JopaExcel 8 ай бұрын

Oh, really? That's amazing! Thanks for the feedback. I'm glad this helped you. 🙏👍

@naveedjunejo3531 3 ай бұрын

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

@vickie9389 3 ай бұрын

You are the best!!!❤❤❤

@hopetube5084 8 ай бұрын

Bro Eady and Helpful thanks

@abhijeetbhagat100 Ай бұрын

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

@user-kv5ty7rs1c 6 ай бұрын

Thanks bro!!!!

@tolga.b. 6 ай бұрын

That this video saves minutes is absolute

@deeptikarki6568 6 ай бұрын

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

@JopaExcel 6 ай бұрын

I'm glad it was useful! Thanks for the feedback 🙏👍

@ahmadaimanbindahakimstaff2510 Ай бұрын

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

@abdulwahabshaikh9696 21 күн бұрын

Thanks bro really its working for me😇

@user-hv2su3ix1i Ай бұрын

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

@asifsaleem3300 8 ай бұрын

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

@JopaExcel 8 ай бұрын

Glad it was helpful! 🙏👍

@user-mq5gk2ol6t 2 ай бұрын

thank you

@sampathkumar-di2vk 5 ай бұрын

Nic explanations

@katink1425 9 ай бұрын

You solved my problem😂 thank you.

@JopaExcel 9 ай бұрын

I'm glad it helped you. 🙏👍

@kumbatimareng 9 ай бұрын

thank you sir.. Hopefully you can also tutor us another vid using if functions that uses computation.

@JopaExcel 8 ай бұрын

Thanks for the comment. 🙏👍 I'll definitely bring more videos on the subject.

@user-cl1qc5hi7k 6 ай бұрын

Hi mate! this is a different scenario for your IF function. What if column A, column B and column C has a dropdown option, and you need them for the result of column D. What would be the formula?

@ginapyzalski127 6 ай бұрын

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.

@JopaExcel 6 ай бұрын

I'm glad it was useful. Thank you for the feedback. Excel has a lot of functions that can save time. I'm glad this one helped you 🙏👍

@abdulhamidalhaddadi2255 2 ай бұрын

Thank you

@JopaExcel Ай бұрын

🙏👍

@quentinfourie2173 5 ай бұрын

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, N=6.0....... But still, maintain the name order for all the scores on the left-most column? Thanks!

@bateyboo1 7 ай бұрын

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

@mwsiviero 7 ай бұрын

I'd like to know it too

@gordospeti 7 ай бұрын

A nice example of nesting! However, my Excel requires that semicolons be used rather than commas.

@ibnadam1987 3 ай бұрын

What software are you using for video editing and screen recording?

@tsehayenegash8394 5 ай бұрын

Nice video. How can I remove the unwanted temperature by using If condition in excell? I want to the temperature less than17 degree C and greater than -70 degree C

@basilioalmeida6392 4 ай бұрын

How to best solve the following problem? I have two workbooks, WB1 and WB2. In WB1, If M6 in WB1 is equal to K3 in WB2, I want M7 in WB1 to have the same information in Q7 on WB2. Thanks.

@fidesybanez7510 6 ай бұрын

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?

@user-ev4pm2sw1x 6 ай бұрын

Can give a SUM FUNCTIONS SKILLS SUMMARY EXCEL EXERCISE?

@santoshkrishnan4624 2 ай бұрын

I am placing/writing a formula in cell C1 In A1 - Its EXPIRY DATE In B1 - Its RENEWAL DATE =IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT") The above formula is working. Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()

@Tem209 4 ай бұрын

Can you upload this excel sheet here? would have helped

@johnaxta1008 7 ай бұрын

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?

@JopaExcel 7 ай бұрын

Glad it helped you! The reason I didn't use the IFS is because it's not available in all Excel versions. If you have the most recent versions, you can use IFS, but if you have all the other versions, you can't. I'm always trying to show things that most people can do. 🙏👍

@mbarakomar5805 8 күн бұрын

@@JopaExcelIts true in my excel there is no IFS function, the video helped me.

@anthonybuda3807 Ай бұрын

What did you press to lock K2 cell sir?

@JopaExcel 28 күн бұрын

F4 key, sir! 🙏👍 Or you can manually input the dollar sign $.

@davidspear9790 3 ай бұрын

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

@shahjadhashmi5323 6 ай бұрын

❤

@JopaExcel 6 ай бұрын

Thanks! 🙏👍

@rahmakabeel661 3 ай бұрын

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

@hussinali8858 4 ай бұрын

Hi, how to create a formulae, eg: if in Column A1 is 1, therefore the Answer shall be the same as shown in it.

@reddy8861 9 ай бұрын

Can we use IF & AND functions for multiple conditions?

@JopaExcel 8 ай бұрын

Yes, I'm definitely. I have a video about logic functions, maybe it can help you: kzfaq.info/get/bejne/e69nZ86g15_JaGQ.html But anyway, I'm going to make a more specific video about this, I think it's very important. The AND and also the OR, can be used with the IF function to amplify, increase the number of criteria you can use.

@ahmadaimanbindahakimstaff2510 Ай бұрын

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

@JopaExcel Ай бұрын

100%, sir. You can nest everything. I'm serious, if it works, it is right. 🙏👍

@ahmadaimanbindahakimstaff2510 Ай бұрын

@@JopaExcel ok noted Sir.. :)

@Santok110 10 ай бұрын

Sir, how much if conditions can add in one formula

@JopaExcel 10 ай бұрын

You got me there... But, searching on Google, it's says you can specify up to 127 range/criteria pairs in your formulas. Or until the computer crashes lol

@geetkht84 4 ай бұрын

kindly provide excel sheet

@globalfootballer1 8 ай бұрын

What is the difference between using $..$(absolute reference) and simply typing a number?

@JopaExcel 8 ай бұрын

Hey, Daniel! Thanks for the question. Look, if you use as the criteria a number, that you entered manually, you do not need to lock the reference as the criteria will not change. It will always be the same value. But, on the other hand, if you select a value to use as a criteria that is in another cell, you need to lock that cell ($..$) so that the reference always remains in the same location.

@globalfootballer1 8 ай бұрын

thank you , sir@@JopaExcel . Let's I choose to use a criteria as a number (50) entered manually, is it a must to write it like "50", just 50 can do? when are we supposed to use "..." ?

@JopaExcel 8 ай бұрын

With number you dont need to use quotations. However, if it is a text, you need to use them. 👍

@AmmieFernandez 6 ай бұрын

We did this exercise today on the spot. I use ";" for the next "IF". 😂 Doesn't work. New version is "," 😁. Thank goodness I got it before the time ends 😂😂😂

@JopaExcel 6 ай бұрын

In English I always used commas. I believe it should change mainly due to the language... But I'm glad it worked! Thanks for the feedback

@JopaExcel 6 ай бұрын

I get lost sometimes too. Sometimes it is a comma or semicolon. And if it's numbers, to separate the decimal places, sometimes it's a "point" and sometimes it's "comma". 🤣

@geetkht84 4 ай бұрын

What formula will be used in this? A---------->=15 B----------=60 C-----------=120 D----------

@iqrazonecommerce6126 7 ай бұрын

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

@valmir144 2 ай бұрын

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

@JopaExcel 2 ай бұрын

Do you want to use IF function with only two criteria? Here's the video: kzfaq.info/get/bejne/qrSmhs-FmbG3gI0.html You can also use IF function with more criteria to check a value, heres: kzfaq.info/get/bejne/gdFjZtiTp6_MlI0.html Another thing, be more respectful, please. No one owes you anything.

@valmir144 2 ай бұрын

@@JopaExcel Thanks! Just was expressing my frustration bro. Don't meant to be disrespectful. Sorry if I sounded so...

@valmir144 2 ай бұрын

@@JopaExcel I have two if formulas, each one with different "if true" and "if false" values. Is it possible to combine them?