Тёмный

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

MyOnlineTrainingHub
Подписаться 615 тыс.
Просмотров 148 тыс.
50% 1

Learn how to use Excel's IF Statement to write logical test IF formulas.
🔻EXCEL IF FUNCTION STEP BY STEP WRITTEN TUTORIAL HERE: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
0:19 IF Syntax
1:02 IF Formula Example
3:06 Outro

Наука

Опубликовано:

 

29 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@JatinGandhi1985
@JatinGandhi1985 3 года назад
You are the Best, i will see all your videos and keep learning...Take care of yourself.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks, Jatin! And you :-)
@arturoguzman5230
@arturoguzman5230 3 года назад
Wow 9 Years ago.😍
@musabtaherwala1114
@musabtaherwala1114 3 года назад
Thank you mam you re greatt...and also your accent
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks so much :-)
@dipaklama6603
@dipaklama6603 3 года назад
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
@MyOnlineTrainingHub 3 года назад
Sure, please find IF, IFS, Nested IFs, IF AND, IF OR all in one video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0zTeXujtOZI.html
@rushdimohammad6181
@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
@MyOnlineTrainingHub Год назад
Thanks so much! If the file is available for download there will be a link in the video description.
@kiridhruv
@kiridhruv 6 лет назад
Very informative :) Thanks 🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 лет назад
You're welcome :-)
@AHXMD
@AHXMD 11 лет назад
I love your accent !
@darrellmartinquinn6605
@darrellmartinquinn6605 3 года назад
good video.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad you enjoyed it, Darrell :-)
@darrellmartinquinn6605
@darrellmartinquinn6605 3 года назад
Thank you. Besides your video, I actually follow "Vanna Excel"'s video. These two are worth to watch.
@ahmadalali96
@ahmadalali96 Год назад
Ammmmmmmazing 🌷🌷🌷
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@ahmadalali96
@ahmadalali96 Год назад
@@MyOnlineTrainingHub All the content you provide is very useful, here on your RU-vid channel, or on all other platforms,, Thank you very much for your valuable time that you give us. 🌷
@Layya-m3
@Layya-m3 4 года назад
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
@MyOnlineTrainingHub 4 года назад
Because column F contains a formula that multiplies the Units by the Average $k to get the Total $k.
@Layya-m3
@Layya-m3 4 года назад
@@MyOnlineTrainingHub got that... thanks
@kevingideon246
@kevingideon246 3 года назад
What if I have a 3 way. which means if its lower then 100000, greater then 100000 and greater then 150000?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Hi Kevin, you can use a nested IF formula to handle different tiers: www.myonlinetraininghub.com/excel-nested-ifs-explained
@kevingideon246
@kevingideon246 3 года назад
@@MyOnlineTrainingHub thank you so much u guys are really awesome!
@stefanbachrodt7072
@stefanbachrodt7072 3 года назад
=IF(B2="Saturday" or "Sunday","YES","NO")... The formula is perfectly logical, excel is dumb if it can't understand that.
Далее
🎙️ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ💖
3:23:13
This 1 Excel function can do 90% of your calculations!
5:41
Excel SUM and SUMIF Formula in Excel
7:53
Просмотров 316 тыс.
Excel Mini Charts - BETTER than Sparklines!
10:34
Просмотров 185 тыс.
Top 10 Most Important Intermediate Excel Functions
23:56
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
IF statements with VLOOKUPs  -- Microsoft Excel
3:12
Просмотров 204 тыс.
Excel Goal Seek Explained in Simple Steps
5:55
Просмотров 409 тыс.
iPhone 16 - КРУТЕЙШИЕ ИННОВАЦИИ
4:50
Кто производит iPhone?
0:59
Просмотров 417 тыс.