Learn these topics: 1. (00:01) Introduction. 2. (00:52) What IF Function does? 3. (01:17) Logical Formula. 4. (01:51) Comparative Operators. 5. (03:42) Payroll Bonus Formula. Description of three arguments in IF Function. See how to put 1 of 2 numbers into a cell. 6. (04:55) Data Usage Formula. See how to put 1 of 2 test items into a cell. 7. (06:00) Commission Formula. See how to put 1 of 2 numbers into a formula. 8. (07:15) Don’t get tricked by Number Formatting. 9. (07:47) Payroll Overtime Formula. 10. (08:31) Income Statement Formula. 11. (09:12) OR Function with IF Function. 12. (10:37) AND Function with IF Function. 13. (11:40) Nested IF Functions to put 1 of 3 things into a cell. Social Security Hurdle Formula. 14. (13:21) Bad Use for IF Function. When not to use IF function, but Lookup Function instead. 15. (13:50) IF Function Array Formula. Standard Deviation Formula. 16. (15:26) IS Functions in IF Function. Account Balance Formula. 17. (16:50) Summary and End Video Links.
Ive been watching lots of your videos over the last week or so, trying to learn excel for job interviews. I think this video has taught me the most and made me think ive cross the threshold from "novice" to "intermediate". Despite having learned about pivot tables and power query from your other videos, I think having to actually think about what formula im writing has moved me to the next level.
Nice video Mike. IF function is like a "LOGIC BREAD". The entire purpose of this function is to hold other functions inside it together between it's two slices (opening and closing brackets) to deliver a tasty result.However the beauty of this function is it can even be used inside other function /s.Wonderful !!!
I love that some of the Magic Tricks highlight important Excel skills. Like this one - although I have already completed the chapter on logicals from the Dragon videos, I have decided to watch this one as well. And I very much appreciate that many "must-knowns" are repeated across the excelisfun channel: cell references, formatting as a facade, proper data sets, cross-tabulation, no chartjunk, arrays etc. Excellent teaching. Thank you.
In fact, that is my hallmark: never not teach efficient methods : ) Always show the hows and whys - that way we an have fun with Excel and gain great Power!
@@zt.5677 Well said, when you said: "Think Excel". In fact in the business, accounting, finance, data analysis, scientific world where people have to build models, if you do not complete see all tasks through the lenses of Excel, you are probably inefficient and not very good at your job. For each analytic task, you know you are good when you think in Excel; when you see all the parameters of a task, and as you think about solving the problem, the parameters fall into a spreadsheet and you see Excel formulas, functions and features to solve the problem.
Bravo, Mike, thank you so much for the Videos summarising so many practical and important examples how the formulas can be used. So enjoyable, have a great day Mike 🤗
People sometimes say to me that when I am bored I play with excel.....its tru, but only since you really made it fun.... thanks for all you doing here.
How did you know? I have been working on this video for the last few weeks... Some parts of it, like the Array part, took me more than 10 takes until I got the exact story i wanted.
Dear Mike after learning IF function from you I ask one question from IF function =IF(MIKE>EXCEL,"Yes Mike is Greater","No") IF Answer is Mike is Greater. Mike I want to give you special thanks for making me expert in excel.
@@harismuhammad1569 I am happy too. You can help me continue to provide free Excel Education to the world by commenting and clicking thumbs up on every video that you learn from : )
Hi Mike.. thanks for the EXCELlent IF function workout :) It's an oldie but a goodie.. super useful in so many situations. Thanks for all the tips. Thumbs up for ExcelIsFun!!
Hi, Sir Good Evening. Wow, "IF" function is the most powerful formula of the excel. And outstanding example described you. Every example is the to much. So thank u so much really you are genius in excel.
What type of type mismatch? 43="43", number not equaling Text Number? Try: 43="43"+0 to get them both to numbers or 43&""="43" to get them both to text.
@@excelisfun getting the error on the first half of the IF line Sub ColorMe() Dim sht2 As Worksheet Dim LR As Long Set sht2 = Worksheets("Running") Dim i As Integer LR = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To LR If sht2.Cells(i, 14).Value = sht2.Cells(i, 15).Value Then sht2.Cells(i, 14).Interior.Color = vbWhite Next i End Sub
More of a theoretical than a Excel question, do you know WHY binary numbers are 1 and 0? Why is True = 1 and False = 0? Why is 1 and 0 used over any other numeric possibility?
Well in Excel, FALSE = 0 ALL Other Non-Zero Numbers = TRUE. Try it. It works in all logical functions, Conditional Formatting and so on. But as Why Binary is 0 and 1. I am not sure, but probably because they are small... Anyone else know the history of that or the practicality of why all our devises are run by 0s and 1s?
@@excelisfun Reason this was provoked was bc I read that Arthur C Clarke stated "Any sufficiently advanced technology is indistinguishable from magic" and made me think of the binary system used in many devices. I believe numbers have meanings especially those in pairs (11, 22, 33 etc) and sometimes are used in wicked ways by numerologists, so just seeing if there is a correlation.
Because our digital computers are all based on transistors, and they model only two states: current is blocked: zero, and current flows through: one. So they had to learn everything in base 2. Come back in a few decades (maybe just one?) and qbits and quantum computing will be more prevalent: they allow for more states and all at the same time as well (superposition).
@@GeertDelmulle I looked into transistors and quantum physics and the more I'm researching about their founders Wolfgang Pauli and Paul Dirac the more I'm convinced that they had satanic beliefs, with statements like "God made the bulk, surfaces were invented by the devil". The eminent Jack Parsons, whom we associate with space satellites was openly a devil worshipper! This whole technology stuff is creepy and can see why Arthur C Clarke said what he said when you look into it....food for thought.
I have so many on Data Analysis. Here is an older one that has many examples of Excel Worksheet Data Analysis: th-cam.com/video/i5WiYh2jmG8/w-d-xo.html Here is a 10 video playlist of the Basics of Data Analysis: th-cam.com/play/PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT.html Advanced Excel Data Analysis playlist: th-cam.com/play/PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1.html
Hi Mike, One challenge, the last example shows how to calculate the new balance. How can I do that in Power Pivot? Thanks for sharing so much knowledge.
Many of the numerical examples can be achieved without the IF-function: aka. mixed-mode calculations. Mike has lots of video’s on that as well. And it gets really crazy if you start mixing that with array calculations. And that’s where the name “crazy array formulas” comes from (not really). ;-)
Good points, Geert!!! P.S. You are right about alternative formulas without IF. The Social Security example in this video was: =IF(C12>$E$8,0,IF($E$8-C12
Good Morning Professor Mike! Great video as always! Can you point me to one of your videos that show using the If function for 3 logical tests to include >=50 between a certain number range i.e >50-100.
Here if for counting between an upper and lower limit: th-cam.com/video/yRpUSXg7LtY/w-d-xo.html I am not sure what you need the IF for. Can you explain more about your goals?
You have an awesome Channel! You have taught me so much, I can thank you enough! It has saved me many times. Now I look to you for some non-Excel advise. What software do you use to create your videos? I need to make some videos for work to train our people on some of our in-house tools. Thanks
Thanks, Great Teacher. Is it me or is there a need to revise the Goal statement in example 6, as Net Loss would always result where total expenses are greater than Total Revenue. Again, thanks
@@excelisfun , You can't be serious )) I have put two links below on S Curve in Excel. But I think you would expalin it a lot better than them )) www.educba.com/s-curve-in-excel/ www.wallstreetmojo.com/s-curve-in-excel/ What do you think?
hello Mr ,the data is crop type, variety , planted date and area so how to calculate the the area of cereal with different age groups(the number of month)?
I have many videos about this. In my Analytics class here are the three videos: 1) th-cam.com/video/qBzBinHSPa4/w-d-xo.html 2) th-cam.com/video/EWJPPUvJ7c8/w-d-xo.html 3) th-cam.com/video/3komnmHvglc/w-d-xo.html 4) th-cam.com/video/RaQD0JZKHYk/w-d-xo.html Here is the link for the whole class: th-cam.com/play/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.html
Here are 2 links on on an S curve, for some reason they didn't come up in my reply to you: www.educba.com/s-curve-in-excel/ www.wallstreetmojo.com/s-curve-in-excel/
Why are we still talking about the IF function when we have the more intuitive and efficient IFS function? Everyone knows that IF is obsolete and has completed its mission. RIP IF!
The main difference between IF and IFS is that The IFS does not have a value_if_false, so you can never have an option that catches all others that do not match the previous TRUEs. So with IFS you always have to list all options. Both are good, but different.
Consider this example from Microsoft Office Support: =IFS(A2>89,"A",A2>79,"B",A2>69,"C",A2>59,"D",TRUE,"F"), the last condition "TRUE" catches all others that do not satisfy the prior conditions.
@@dannyleung2796 Just like Microsoft to give a horrible example. They are idiots. That is a situation where VLOOKUP or XLOOKUP is MUCH more efficient. However, you comment about how you can force IFS to consider other situations is great! Thanks for the tip, Danny! P.S. I do have a video that compares and contrasts IF and IFS here: th-cam.com/video/BSArRLKeNaw/w-d-xo.html
Learn these topics:
1. (00:01) Introduction.
2. (00:52) What IF Function does?
3. (01:17) Logical Formula.
4. (01:51) Comparative Operators.
5. (03:42) Payroll Bonus Formula. Description of three arguments in IF Function. See how to put 1 of 2 numbers into a cell.
6. (04:55) Data Usage Formula. See how to put 1 of 2 test items into a cell.
7. (06:00) Commission Formula. See how to put 1 of 2 numbers into a formula.
8. (07:15) Don’t get tricked by Number Formatting.
9. (07:47) Payroll Overtime Formula.
10. (08:31) Income Statement Formula.
11. (09:12) OR Function with IF Function.
12. (10:37) AND Function with IF Function.
13. (11:40) Nested IF Functions to put 1 of 3 things into a cell. Social Security Hurdle Formula.
14. (13:21) Bad Use for IF Function. When not to use IF function, but Lookup Function instead.
15. (13:50) IF Function Array Formula. Standard Deviation Formula.
16. (15:26) IS Functions in IF Function. Account Balance Formula.
17. (16:50) Summary and End Video Links.
The fact that I watch the videos even if I already have the knowledge about their content speaks for this channel. As always super explained. 😍👍
Ditto
Thank you for your kind words, Nico : ) : ) : )
A comprehensive Lesson for IF Function, Thank you Very Very Much Mr. Mike
You are very welcome, Ogwal!!!
True!
Thank you for a comprehensive IF video.
You are welcome, teammate Leila : ) : ) : )
Ive been watching lots of your videos over the last week or so, trying to learn excel for job interviews. I think this video has taught me the most and made me think ive cross the threshold from "novice" to "intermediate". Despite having learned about pivot tables and power query from your other videos, I think having to actually think about what formula im writing has moved me to the next level.
Good luck with your up and coming job interviews!!!
Nice video Mike. IF function is like a "LOGIC BREAD". The entire purpose of this function is to hold other functions inside it together between it's two slices (opening and closing brackets) to deliver a tasty result.However the beauty of this function is it can even be used inside other function /s.Wonderful !!!
Love you term: LOGIC BREAD!!!!! The IF can deliver a tasty result!!!! Thanks for the creative comment, Sachin!!!
thanks Mike and i don't understand why someone dislike the video,
is free learning online !!!!
i keep thumbs up for you
thanks
Everything I need to know to show off in the office that I learnt it ONLY from the best tutor of excel on TH-cam. Thanks Mike.
Always glad to help, Simoiya!!!
I love that some of the Magic Tricks highlight important Excel skills. Like this one - although I have already completed the chapter on logicals from the Dragon videos, I have decided to watch this one as well. And I very much appreciate that many "must-knowns" are repeated across the excelisfun channel: cell references, formatting as a facade, proper data sets, cross-tabulation, no chartjunk, arrays etc. Excellent teaching. Thank you.
In fact, that is my hallmark: never not teach efficient methods : ) Always show the hows and whys - that way we an have fun with Excel and gain great Power!
Thanks for your cool comments and the thumbs ups, Z T!!!
@@excelisfun Yes, you show us how to "think Excel" to solve the problems. That is where the real power is, as you say.
@@zt.5677 Well said, when you said: "Think Excel". In fact in the business, accounting, finance, data analysis, scientific world where people have to build models, if you do not complete see all tasks through the lenses of Excel, you are probably inefficient and not very good at your job. For each analytic task, you know you are good when you think in Excel; when you see all the parameters of a task, and as you think about solving the problem, the parameters fall into a spreadsheet and you see Excel formulas, functions and features to solve the problem.
Bravo, Mike, thank you so much for the Videos summarising so many practical and important examples how the formulas can be used.
So enjoyable, have a great day Mike 🤗
Glad it is an enjoyable summary for you, Katerina : ) : ) : )
Mike this was an epic IF function video, well done!!!
Thanks, Chris!!!! Thanks for your always epic comments : ) : )
Excel is not my career, I'm just a follower, and beleave me .. nothing can reward you as you really diserve , thanks for all sharings .
You are welcome, tha2ir, and thanks for your kind words!
Love the one stop shopping if function video. Thanks Mike!
People sometimes say to me that when I am bored I play with excel.....its tru, but only since you really made it fun.... thanks for all you doing here.
Now this is amazing! I didn't know all of these Excel IF functions / ways to use IF function ! Great work puting them in one video, Mike 👏🏻
You are welcome, yosra!!!
So much work put into this video, with time stamps and all!! Thank you.
How did you know? I have been working on this video for the last few weeks... Some parts of it, like the Array part, took me more than 10 takes until I got the exact story i wanted.
@@excelisfun. That's why you are the best!!
💕❤️💕❤️💕
Thank you for the love, Hoi Yin Wan!!!!!! : )
Dear Mike after learning IF function from you I ask one question from IF function =IF(MIKE>EXCEL,"Yes Mike is Greater","No") IF Answer is Mike is Greater. Mike I want to give you special thanks for making me expert in excel.
You are welcome, Haris!!! I am happy to help, and thank you for your support on each video! P.S. Thanks for the clever IF Formula : )
@@excelisfun Thank you Mike I am also happy to see you response you are my best teacher.
@@harismuhammad1569 I am happy too. You can help me continue to provide free Excel Education to the world by commenting and clicking thumbs up on every video that you learn from : )
=If(No Mike,"Excel is Complicated", "Excel is Fun")
That is a very clever comment, Software Train! Thanks for your amazing support : )
Hi Mike.. thanks for the EXCELlent IF function workout :) It's an oldie but a goodie.. super useful in so many situations. Thanks for all the tips. Thumbs up for ExcelIsFun!!
You are welcome for all the tips, Wayne! Thanks for your amazing support : )
You are an asset! Amazing video.
Glad to be a useful asset, Jefy!!!!
What a great vide! We bless to have you. You need to direct Microsoft on writing their explanation.
Yes, Microsoft is notoriously bad at explaining their great tools.
Awesome Mike, thanks a lot for this great refresher
You are welcome, Saul!!!!
Hi, Sir Good Evening.
Wow, "IF" function is the most powerful formula of the excel. And outstanding example described you. Every example is the to much.
So thank u so much really you are genius in excel.
Thanks for your kind words and support, A b h i s h e k!!!! I will try to keep make great videos : )
Thanks all of this if function example are amazing one stop solution.
Nice to go back to basics. :) :)
Formula Basics to you, John Borg : )
very clear and very inspiring. thank you for your hard work.
LOVE LOVE LOVE these tutorials. Thanks Mr Mike
Love is good! Excel is good! Glad you love the videos, Simoiya!!!
Great video! Keep em coming!
notification for this vid pops up juuuuust as i'm struggling with an If statement. but also getting type mismatch... which is my main problem
What type of type mismatch? 43="43", number not equaling Text Number? Try: 43="43"+0 to get them both to numbers or 43&""="43" to get them both to text.
@@excelisfun getting the error on the first half of the IF line
Sub ColorMe()
Dim sht2 As Worksheet
Dim LR As Long
Set sht2 = Worksheets("Running")
Dim i As Integer
LR = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To LR
If sht2.Cells(i, 14).Value = sht2.Cells(i, 15).Value Then sht2.Cells(i, 14).Interior.Color = vbWhite
Next i
End Sub
@@excelisfun solved it , one cell had a #N/A throwing the whole thing off...
@@ianholm3309 Awesome that you solved it!
Awesome shopping cart. Full of IF function tips. Thank you Mike :)
You are welcome for the shopping Cart!
Another great video from an awesome teacher!
Thanks, Pravin!!!!!
Thank you.
You are welcome, mustapha!!
Thanks Mike
You are welcome, Dave!
Very nice video.
Glad it is nice for you, Ashok!!!!
Good revision of IF formula
Thank u for the video 😀😀.
You are welcome, Janardhan : ) : )
Thank you Mike for another useful refresher 👍. Point #12 has reminded me to re-visit some of the "IS.." functions.
Yes, IS Functions are very handy and sometimes exactly what you want, like ISBLANK to check for empty cells.
More of a theoretical than a Excel question, do you know WHY binary numbers are 1 and 0? Why is True = 1 and False = 0? Why is 1 and 0 used over any other numeric possibility?
Well in Excel, FALSE = 0 ALL Other Non-Zero Numbers = TRUE. Try it. It works in all logical functions, Conditional Formatting and so on. But as Why Binary is 0 and 1. I am not sure, but probably because they are small... Anyone else know the history of that or the practicality of why all our devises are run by 0s and 1s?
@@excelisfun Reason this was provoked was bc I read that Arthur C Clarke stated "Any sufficiently advanced technology is indistinguishable from magic" and made me think of the binary system used in many devices. I believe numbers have meanings especially those in pairs (11, 22, 33 etc) and sometimes are used in wicked ways by numerologists, so just seeing if there is a correlation.
Because our digital computers are all based on transistors, and they model only two states: current is blocked: zero, and current flows through: one. So they had to learn everything in base 2. Come back in a few decades (maybe just one?) and qbits and quantum computing will be more prevalent: they allow for more states and all at the same time as well (superposition).
@@GeertDelmulle Wow!!! Thanks, Geert : ) : ) : ) : )
@@GeertDelmulle I looked into transistors and quantum physics and the more I'm researching about their founders Wolfgang Pauli and Paul Dirac the more I'm convinced that they had satanic beliefs, with statements like "God made the bulk, surfaces were invented by the devil". The eminent Jack Parsons, whom we associate with space satellites was openly a devil worshipper! This whole technology stuff is creepy and can see why Arthur C Clarke said what he said when you look into it....food for thought.
Fantastic
Glad you like it!!!
Boom!Love Everyone of These Functions And Learned Where They Can Be Used!Awesome Tutorial Thank You Mike :):):)
You are BOOM welcome, darryl : ) : ) : ) : )
Useful video could you make an video for excel data analyst skills
I have so many on Data Analysis.
Here is an older one that has many examples of Excel Worksheet Data Analysis: th-cam.com/video/i5WiYh2jmG8/w-d-xo.html
Here is a 10 video playlist of the Basics of Data Analysis: th-cam.com/play/PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT.html
Advanced Excel Data Analysis playlist: th-cam.com/play/PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1.html
Great video thanks Mike!
You are welcome, Graham!!
Thanks for the great video, love the IF function, it is one function gauranteed to impress people when used properly.
Thanks, Roy! I bet you have impressed a lot of people with IF!!!!
@@excelisfun I have done a few times, though I always found it one of the easiest functions to explain the basic use of
Hi Mike,
One challenge, the last example shows how to calculate the new balance. How can I do that in Power Pivot?
Thanks for sharing so much knowledge.
Thnaks mike for the refresh IF, & finllay when IFS come in, we are more comfortable with it by avoiding nesting if :-)
IFS is great for 3 or more!
@@excelisfun Yes Mike it is you shoud add a 20 second and the video will cover all IF possibility :-) Thanks a lot Mike for this quick refresh
I just bought your dvd thank you
You are welcome, Jules! Thank you for your support : )
I like the way to explain everything :)
Thanks, Edmundo : ) : ) : )
Thanks for the video sir...... 👌👌👌
You are welcome, Asif!!!!
As usual amazing
Glad it is amazing for you, Bader!!!!!
Many of the numerical examples can be achieved without the IF-function: aka. mixed-mode calculations.
Mike has lots of video’s on that as well. And it gets really crazy if you start mixing that with array calculations.
And that’s where the name “crazy array formulas” comes from (not really). ;-)
Good points, Geert!!! P.S. You are right about alternative formulas without IF. The Social Security example in this video was: =IF(C12>$E$8,0,IF($E$8-C12
Good Morning Professor Mike! Great video as always! Can you point me to one of your videos that show using the If function for 3 logical tests to include >=50 between a certain number range i.e >50-100.
Here if for counting between an upper and lower limit: th-cam.com/video/yRpUSXg7LtY/w-d-xo.html
I am not sure what you need the IF for. Can you explain more about your goals?
You have an awesome Channel! You have taught me so much, I can thank you enough! It has saved me many times. Now I look to you for some non-Excel advise. What software do you use to create your videos? I need to make some videos for work to train our people on some of our in-house tools. Thanks
You are welcome for the learning here at the excelisfun channel, Bob! I use Camtasia.
Great sir
Glad it is great for you, Koteshwar!!!!
Very useful. Thanks :-)
You are welcome, Alex!!!
>Excel IF Function
Me: "oh yeah, I know how to use the if function"
>17 minute video
Me: "oh......"
Does that mean you learned a lot, Andy?
@@excelisfun yep. Knew how each of the examples worked, but new ways to think about IF
@@PilotPlater Awesome! I love to hear that the video shows new ways to think about IF. That also means new ways to have fun with IF : )
Thanks.
You are welcome, Rupak!!!!
Thanks, Great Teacher. Is it me or is there a need to revise the Goal statement in example 6, as Net Loss would always result where total expenses are greater than Total Revenue. Again, thanks
Yes, I will have to fix that. Thanks for helping me to edit : )
Hello, many thanks for your videos. Can you create new lessons on how to create an S-curve in Excel? I haven't found them on your channel ((
I am sorry, but I do not know what an S Curve is : (
@@excelisfun , You can't be serious )) I have put two links below on S Curve in Excel. But I think you would expalin it a lot better than them ))
www.educba.com/s-curve-in-excel/
www.wallstreetmojo.com/s-curve-in-excel/
What do you think?
Awesome it‐video! It id really Easy with ExcelIsFun 🙂
Glad you like the awesome IF-video, Malina : ) : )
Excel ke Bhagwan = God of Excel !💐
Just a guy having fun with Excel ; )
Great
Glad it is great for you, Relix!
hello Mr ,the data is crop type, variety , planted date and area so how to calculate the the area of cereal with different age groups(the number of month)?
I am not sure.
thanks is not enough for you sir
You are welcome, Faysal!!!
Can u explain what if analysis of excel? Thank you.
I have many videos about this. In my Analytics class here are the three videos:
1) th-cam.com/video/qBzBinHSPa4/w-d-xo.html
2) th-cam.com/video/EWJPPUvJ7c8/w-d-xo.html
3) th-cam.com/video/3komnmHvglc/w-d-xo.html
4) th-cam.com/video/RaQD0JZKHYk/w-d-xo.html
Here is the link for the whole class: th-cam.com/play/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.html
Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : )
@@excelisfun thank u very much :)
How do we combine if, and and or together
Did you watch this video. I showed how : )
. (09:12) OR Function with IF Function.
Here are 2 links on on an S curve, for some reason they didn't come up in my reply to you:
www.educba.com/s-curve-in-excel/
www.wallstreetmojo.com/s-curve-in-excel/
Why are we still talking about the IF function when we have the more intuitive and efficient IFS function? Everyone knows that IF is obsolete and has completed its mission. RIP IF!
The main difference between IF and IFS is that The IFS does not have a value_if_false, so you can never have an option that catches all others that do not match the previous TRUEs. So with IFS you always have to list all options. Both are good, but different.
Consider this example from Microsoft Office Support: =IFS(A2>89,"A",A2>79,"B",A2>69,"C",A2>59,"D",TRUE,"F"), the last condition "TRUE" catches all others that do not satisfy the prior conditions.
@@dannyleung2796 Just like Microsoft to give a horrible example. They are idiots. That is a situation where VLOOKUP or XLOOKUP is MUCH more efficient. However, you comment about how you can force IFS to consider other situations is great! Thanks for the tip, Danny! P.S. I do have a video that compares and contrasts IF and IFS here: th-cam.com/video/BSArRLKeNaw/w-d-xo.html
Great video and explained in easy way. Thank You !
You are welcome for the easy way, Wojciech!!!