IF Function with 4 Criteria in Excel | IF Formula with many Conditions
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- 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
I understand you wanted to demonstrate how to use nested IF function but honestly speaking this is such a classic problem for VLOOKUP with TRUE in the 4th argument. The solution could be so much easier by a single formula rather than having so many nested functions.
Very helpful! Thank you!
Finally I have found a very useful video
Thank you
Thanx, i was looking for this example for long time. Finally i got it 💯👌
I literally did my class assignment with the help of this tutorial and finally got it right .., thank you !!
Oh, really? That's amazing! Thanks for the feedback. I'm glad this helped you. 🙏👍
I like your explanations. I went for classroom based course but you make it clear for me after all the confusions.
thank you so much, finally i found your video is useful
That this video saves minutes is absolute
hi there.. thank you for the tutorial.. your guide is very is useful.. tq
Well defined. Very helpful. Keep uploading these kind of more helpful videos.
at least, i have found this capabilities of Excel!!!
Thanks bro really its working for me😇
Thanks for posting, it really help me alot. thanks again
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.
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 🙏👍
this has been very useful to me, thank you so much
it really work for me for ranging less than and greater than Gross tonnage calculation. thank you so much
Thankyou sooo much 🎉 after repeated mistakes now I properly understood about nested if just in your one video. It was damn helpfull. 😊
I'm glad it was useful! Thanks for the feedback 🙏👍
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
I'd like to know it too
You are the best!!!❤❤❤
Finally find something
What i need actually
❤❤❤❤❤
Clearly defined. Thanks.
Great... Thank you so much... its really very easy....
Glad it was helpful! 🙏👍
It was indeed very useful and informative
It's a really good explanation.thank you so much
You solved my problem😂 thank you.
I'm glad it helped you. 🙏👍
Sir please the software you used to draw coloured boxes and arrows,pls again.
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!
thank you sir.. Hopefully you can also tutor us another vid using if functions that uses computation.
Thanks for the comment. 🙏👍 I'll definitely bring more videos on the subject.
Can you upload this excel sheet here? would have helped
A nice example of nesting! However, my Excel requires that semicolons be used rather than commas.
The IFS function is much simpler when working with multiple values.
thank you
Bro Eady and Helpful thanks
Thanks bro!!!!
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
Nic explanations
What software are you using for video editing and screen recording?
Thank you
🙏👍
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
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?
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. 🙏👍
@@JopaExcelIts true in my excel there is no IFS function, the video helped me.
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?
Can give a SUM FUNCTIONS SKILLS SUMMARY EXCEL EXERCISE?
What did you press to lock K2 cell sir?
F4 key, sir! 🙏👍 Or you can manually input the dollar sign $.
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.
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()
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?
What formula will be used in this?
A---------->=15
B----------=60
C-----------=120
D----------
Hi, how to create a formulae, eg: if in Column A1 is 1, therefore the Answer shall be the same as shown in it.
Can we use IF & AND functions for multiple conditions?
Yes, I'm definitely.
I have a video about logic functions, maybe it can help you: th-cam.com/video/EI74kor9e80/w-d-xo.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.
HI, IT IS OK IF THE LAST CRITERIA WE ALSO MAKE IT IN THE NEST?
100%, sir. You can nest everything. I'm serious, if it works, it is right. 🙏👍
@@JopaExcel ok noted Sir.. :)
What is the difference between using $..$(absolute reference) and simply typing a number?
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.
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 "..." ?
With number you dont need to use quotations. However, if it is a text, you need to use them. 👍
kindly provide excel sheet
Sir, how much if conditions can add in one formula
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
❤
Thanks! 🙏👍
500000 monthly sales. Give the excel formula to convert this amount into 30 days. Do not repeat the amount
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 😂😂😂
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
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". 🤣
everybody teaches exactly the same thing. no one can teach how to get two returns? Damn!
Do you want to use IF function with only two criteria? Here's the video: th-cam.com/video/tNvSlT4KSPY/w-d-xo.html
You can also use IF function with more criteria to check a value, heres: th-cam.com/video/Kk33ubBIhdY/w-d-xo.html
Another thing, be more respectful, please. No one owes you anything.
@@JopaExcel Thanks! Just was expressing my frustration bro. Don't meant to be disrespectful. Sorry if I sounded so...
@@JopaExcel I have two if formulas, each one with different "if true" and "if false" values. Is it possible to combine them?