All 3 Excel IF Statements + how to AVOID PERFORMANCE ISSUES!

IF Statements are essential for all Excel users to master. Unfortunately, many get stuck with nesting and make mistakes that can cause performance issues, which I address in this video.

0:27 Excel IF Formulas
1:39 Nested IF Formulas
3:14 Excel IFS Function
4:24 Mistakes that cause performance issues
6:04 VLOOKUP Alternative
7:52 XLOOKUP Alternative

[IvanCortinas_ES]

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!

[wayneedmondson]

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!!

[retief]

You describe things simple and to the point. Brilliant !!

[darrylmorgan]

Hi Mynda!Great Run Through And Explanation Of These Awesome Functions...Thank You :)

[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

[pascou]

You always explain Excel topics in such a way anyone can understand. :)

[Giovanni-vxxl]

very clever way in how to use dates with tables and vlookup instead of if statements. thanks !

[davidclayton]

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.

[aviman]

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.

[teoxengineer]

Mynda thank you.
Can you make a tutorial about the DGET function and its sub formulas.

[DirectDilSe]

Thank I was looking for this formula from long time and can you upload one video for all benefits of XLookUp? Thanks once again

[GeertDelmulle]

Elementary lesson exquisitely explained. I can’t imagine anyone getting this wrong (or creating such monstrosities).
I guess my imagination is limited at times. ;-)

[overdraftracing]

*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!

[ckliesh]

Thank you for sharing.. How can I create a formula for the following: IF data in cell A1 reads SAW-TCH-TIS, how do I have cell B1 equal cell A1, minus the first 4 letters or numbers? For example cell A1 reads SAW-TCH-TIS. Cell B2 should read TCH-TIS. I have 6, 000 rows of data that I must remove the first 3 letters and the dash. Any assistnace would be greatly appreciated

[cherylrb]

❤️ Help!!! If I am wanting to get a sum difference of two numbers then if it’s greater or less than 5 points am I able to do so? For example I have a spreadsheet with column one data and column two data. I then subtract the two columns to get a total but if it’s 5 more than the total or 5 less than the total I want to flag it in some way. Is this possible? I’ve only seen it done with percentages but I’m want the actual number. Thank you for all you do!! ❤️

[nancynocdvel]

Hi Mynda, this was a great video.. I am new at using the IF function and VLookup. I am trying to do something similar but having difficulties. I have created a file to track my stock portfolio and I want to create an easy dashboard as a summary. However, I want the dashboard to be updated as I make trades. For example, I enter the details of a trade in a column, the I want the premium to go into the dashboard on another sheet. However, since I want the summary/dashboard to auto populate as I make these entries, I need the formulas to be something like, if the premium on the stock transaction page was received in January, it should go to the dashboard page in XX cell, or if it was February it would go in the next cell below, etc. I cannot seem to figure out how to do this. Do you have a video that might help clarify for me what to do in this case? Thank you in advance.

[moathmustafa]

If i Want to make loan schedule with 2 frequency end of month and mid of 3, 6, 9, 12? What we can do?

[tildaun]

how were you able to display the formula to the right of the table?

[watcher]

Hi Mynda, Hope you are doing just great! I am working on an assignment, in my sheet I have to make some data in the K column by using the data in the B column and the blank cells are in the same order in both the B and K columns. The problem is when I use the formula =IF(B10="", "", P$4*B3+(1-P$4)*K3) the logical part of the formula is correct (I mean the result is filled in the correct cell or I must say IF part is working ) but the calculation part is picking wrong cells for the calculation I mean P$4*B3+(1-P$4)*K3) Band K cells are wrongly picked up resulting correct cell but wrong data. can you suggest anything for this, please? hope you have time ..thnx for checking...Siraj(India)

[stefanleys]

Hallo Mynda and all here. I was struggling with an If and formula today and cannot solve it properly… it is as follows: I want to calculate the salary cost per year of employees until they go on pension. My available data are as follows: dates people will be go on pension and their salary cost in a specific year + 2% every next year.
I have the salary cost per employee and their retirement date (for example: 15/05/2023) coloms and the years 2019 till 2050 in a row (title).
At the bottom of my data I added 2 rows as follows: first row starts with 01/01/2019 and second row starts with 31/12/2019. This so I can calculate the cost for several months when not a full year. For example : retirement date here above = 15/05/2023 so the total cost for this employee in 2023 will be 15/05/2023 minus 01/01/2023 x (salary cost x 1, 02 index)/365 days.
However I want one formula so that it doesn’t calculate the salary cost as soon as the retirement date is surpassed, but still calculate the salary cost when retirement date has not been reached yet… here lies my issue that I can only achieve one condition and not both in one formula :(
I need this one formula so that when I change the retirement date the cost is automatically adjusted all years correctly.
If I am not mistaken I had this formula: IF(AND(condition 1;condition2);value true;0).
Condition 1 and 2 are both to do with the dates here above, but I cannot get it right… or I end up with huge amounts vertically or I end up with negative amounts horizontally etc. I just cannot figure it out 🤯🤯🤯🤕
If you Mynda or anyone else could help me with this enigma then I would be very grateful…

My table simplified:
Names - retirement date - salary cost 2019 - 2019 - 2020 - 2021 - …. - 2050
Name 1 - 02/04/2019 - 55.000 eur
Name 2 - 04/07/2020 - 70.000 eur
•••
Name 71 - 14/09/2034 - 116.000 eur
•••

Result should all be amounts in 2019. In colom 2020 the values of the employees who retired in 2019 should be zero and amounts vertically and horizontally till you only have amounts in colom with year 2050 for those employees who retire in 2050.
So as I said I would be very grateful if someone could help me out on this one please 😵‍💫