All 3 Excel IF Statements + how to AVOID PERFORMANCE ISSUES! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Overdraft
-threadjack- I was interested to see that for your xlookup you selected the actual data in the table rather than the whole column via the down arrow you get by hovering on the column header. Was that just personal preference or is there an advantage to doing it that way? I'm usually doing lookups on long tables where grabbing the data would be a bit more work...
PS. Thank you for IFS... I had no idea that existed!
reply
-threadjack- I was interested to see that for your xlookup you selected the actual data in the table rather than the whole column via the down arrow you get by hovering on the column header. Was that just personal preference or is there an advantage to doing it that way? I'm usually doing lookups on long tables where grabbing the data would be a bit more work...
PS. Thank you for IFS... I had no idea that existed!
reply
Patrick
IF is great for single checks, especially if you-re going to return true or false: =IF(test,) is short and easy to understand
IFS is great for several checks
The various LOOKUP functions are great for many checks
Combining functions like IFS, FILTER, XLOOKUP LET, and LAMBDA takes it one step further
Great tutorial as always
reply
IF is great for single checks, especially if you-re going to return true or false: =IF(test,) is short and easy to understand
IFS is great for several checks
The various LOOKUP functions are great for many checks
Combining functions like IFS, FILTER, XLOOKUP LET, and LAMBDA takes it one step further
Great tutorial as always
reply
Alessio
I was discussing about this topic litterally yesterday!
I did nested if to take care of a similar case (prices based on volumes ranges) and I was wondering if there was a smarter way to do it...I think that the -Vlookup 1- has just saved me quite some time, thank you so much!!
reply
I was discussing about this topic litterally yesterday!
I did nested if to take care of a similar case (prices based on volumes ranges) and I was wondering if there was a smarter way to do it...I think that the -Vlookup 1- has just saved me quite some time, thank you so much!!
reply
Greg
One correction (I believe), the good thing about XLOOKUP as it does NOT require it to be sorted as you state at the end of the video. It checks all values and gets the one that is the next lowest (or highest) value.
reply
One correction (I believe), the good thing about XLOOKUP as it does NOT require it to be sorted as you state at the end of the video. It checks all values and gets the one that is the next lowest (or highest) value.
reply
apamwamba
WOW! Excellent Video!!. And the extra benefit is that this knowledge can be applied in any programming language and SQL. Its called Decision Making...We are very lucky to have our very own MVP : Mynda
reply
WOW! Excellent Video!!. And the extra benefit is that this knowledge can be applied in any programming language and SQL. Its called Decision Making...We are very lucky to have our very own MVP : Mynda
reply
Iv-n
Excellent tutorial and practical.
The important thing is to have the examples with cases that are close to real life and you do it. Thank you very much Mynda. Learning from a great teacher!
reply
Excellent tutorial and practical.
The important thing is to have the examples with cases that are close to real life and you do it. Thank you very much Mynda. Learning from a great teacher!
reply
David
Another advantage of using lookup is if you wish to introduce a new 'if' such as 120 days = -legal letter-,then the lookup range is easier to amend than the nested if formula.
reply
Another advantage of using lookup is if you wish to introduce a new 'if' such as 120 days = -legal letter-,then the lookup range is easier to amend than the nested if formula.
reply
Geert
Elementary lesson exquisitely explained. I can-t imagine anyone getting this wrong (or creating such monstrosities).
I guess my imagination is limited at times. ;-)
reply
Elementary lesson exquisitely explained. I can-t imagine anyone getting this wrong (or creating such monstrosities).
I guess my imagination is limited at times. ;-)
reply
Tony
Quality tutorial as ever. 21 nested IFs? Might make perfect sense at the time of writing but any more than 24 hours later and it would be a nightmare.
reply
Quality tutorial as ever. 21 nested IFs? Might make perfect sense at the time of writing but any more than 24 hours later and it would be a nightmare.
reply
Wayne
Hi Mynda. The multi-nested IF example was classic. Thanks for showing people how to think of doing a lookup instead of IF, IF, IF :)) Thumbs up!!
reply
Hi Mynda. The multi-nested IF example was classic. Thanks for showing people how to think of doing a lookup instead of IF, IF, IF :)) Thumbs up!!
reply
Add a review, comment
Other channel videos
