Excel IF Statement Explained - learn how to write Excel IF Formulas

[@heisdolo]

I've travelled back in time to start Learning Excel for your channel. Great video.

[@MyOnlineTrainingHub]

Great to hear!

[@JatinGandhi1985]

You are the Best, i will see all your videos and keep learning...Take care of yourself.

[@MyOnlineTrainingHub]

Thanks, Jatin! And you :-)

[@musabtaherwala1114]

Thank you mam you re greatt...and also your accent

[@MyOnlineTrainingHub]

Thanks so much :-)

[@rushdimohammad6181]

Mazing videos, I should watch all the videos in this channel. Is it possible to download the material in the video so that I work parallel with the instructor? Thanks a million.

[@MyOnlineTrainingHub]

Thanks so much! If the file is available for download there will be a link in the video description.

[@arturoguzman5230]

Wow 9 Years ago.😍

[@ahmadalali96]

Ammmmmmmazing 🌷🌷🌷

[@MyOnlineTrainingHub]

Glad it was helpful!

[@ahmadalali96]

@@MyOnlineTrainingHub All the content you provide is very useful, here on your KZbin channel, or on all other platforms,, Thank you very much for your valuable time that you give us. 🌷

[@dipaklama6603]

Can you please make the more detailed IF/IFS tutorial with the st version of excel? this also helpful but it's very old version

[@MyOnlineTrainingHub]

Sure, please find IF, IFS, Nested IFs, IF AND, IF OR all in one video here: kzbin.info/www/bejne/Zqu3lourn9mCkKs

[@darrellmartinquinn6605]

good video.

[@MyOnlineTrainingHub]

Glad you enjoyed it, Darrell :-)

[@darrellmartinquinn6605]

Thank you. Besides your video, I actually follow "Vanna Excel"'s video. These two are worth to watch.

[@kiridhruv]

Very informative :) Thanks 🙏

[@MyOnlineTrainingHub]

You're welcome :-)

[@AHXMD]

I love your accent !

[@kevingideon246]

What if I have a 3 way. which means if its lower then 100000, greater then 100000 and greater then 150000?

[@MyOnlineTrainingHub]

Hi Kevin, you can use a nested IF formula to handle different tiers: www.myonlinetraininghub.com/excel-nested-ifs-explained

[@kevingideon246]

@@MyOnlineTrainingHub thank you so much u guys are really awesome!

[@Layya-m3]

Why did the value if F2 change when you changed D2 to 6??? Only the commission should change right why the total sales changed?

[@MyOnlineTrainingHub]

Because column F contains a formula that multiplies the Units by the Average $k to get the Total $k.

[@Layya-m3]

@@MyOnlineTrainingHub got that... thanks

[@stefanbachrodt7072]

=IF(B2="Saturday" or "Sunday","YES","NO")... The formula is perfectly logical, excel is dumb if it can't understand that.