# Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

Learn how to use Excel’s IF Function in your reports.
Check the Excel Essentials Course:

We cover a few examples in this tutorial including:

1. Simple IF function (also with greater than or less than checks).
2. IF Formula together with AND logical test to decide outcome if more than one condition is met.
3. Nested IF formula (an IF inside another IF) to check for multiple criteria.
4. IF formula with OR function (to check if “either” condition is met and then decide the outcome).
5. We also take a look at using formulas (other calculations) inside the IF function and finally:
6. How to use symbols as the result of the IF formula

Your IF formula isn’t working? One of the main mistakes is the “else” argument. That’s the last argument inside the IF function. Make sure you haven’t forgotten to specify what should happen “if” the condition isn’t met. In case you have more than one condition, here’s the place to add the second “if” statement. An IF formula inside another IF formula is called a nested if function.

Conditional formatting symbols:
Custom formatting symbols:
If Function with Partial text match:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Get Office 365:
Microsoft Surface:

GEAR
Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Nguồn: https://poledancestyle.com/

Xem thêm bài viết khác: https://poledancestyle.com/tong-hop/

Related Posts

## Lời Tâm Sự Của Annabelle | Phim Hài Ghiền Mì Gõ

June 17, 2020

Lời Tâm Sự Của Annabelle | Phim Hài Ghiền Mì Gõ Mắt Biếc đang phát trên Galaxy Play Đăng ký...

## Top 10 – Rarest LoL Skins 2015

June 14, 2020

Want to know what the rarest skins in League of Legends are? Look no further, due to popular demand we’ve...

## Bói Hắt Xì Hơi – Giải mã hiện tượng Hắt Xì Hơi liên tục theo giờ

June 11, 2020

Bói Hắt Xì Hơi – Giải mã hiện tượng Hắt Xì Hơi liên tục theo giờ.16:13:23.☆Chuyên mục: Xem tướng.Đã xem:...

## Hướng dẫn tạo tài khoản Weibo dễ dàng 2019 – Sina Weibo

June 19, 2020

Chào các bạn , mình đã có thử áp dụng cách tạo QQ ở clip trước vào Weibo và kết...

## Hướng dẫn cài đặt phần mềm KBHXH, update KBHXH tránh các lỗi not responding

June 15, 2020

Hướng dẫn cài đặt phần mềm KBHXH, update KBHXH tránh các lỗi not responding ———————————————————————————————————– 🎉 Thuế là nguồn thu...

## Hướng dẫn cắt File PDF

June 12, 2020

video hướng dẫn cài foxit reader: ———————————————————————————————— Hãy đăng ký kênh,like và share để xem nhiều video bổ hơn Đăng...

## Soạn thảo tự động nhiều HĐ lao động sử dụng trộn văn bản – mailing

June 19, 2020

Soạn thảo tự động nhiều HĐ lao động sử dụng trộn văn bản – mailing Trong các tác văn phòng...

## Bài 6. Thiết kế bộ Lịch Âm Dương 2016 bằng Corel Draw X7

June 8, 2020

Với một số thủ thuật cơ bản, bạn có thể lấy từ Internet bộ lịch số âm dương 2016 (hay...

## Hướng dẫn khắc bút chì nhanh với dụng cụ sẵn có|TranVuPencil

June 12, 2020

#hockhacbut #quatangynghia#tranvupencil #khacbutchi #pencilcarving Xin chào mọi người! Clip này mình tạo ra dành cho những bạn chưa từng biết...

## Lần đầu sỡ hữu Skin hiếm nhất Thế giới | Pax Jax Quá dữ !!!

June 9, 2020

#lienminh #testskin #jaxpax Skin hiếm lắm à nha anh em, anh em thấy thích thì like + subcrise cho mình...

## BẠCH TUYẾT CHUYỆN TRAI NGOAN KỂ (PARODY) | Rik x Lil'One | Nhạc Chế

June 19, 2020

Ngày xửa ngày xưa, chuyện về nàng Tuyết và mụ Thuỷ do Trai Ngoan kể =)) Chế lời & Thể...

## Hướng dẫn cách đổi mật khẩu Gmail – Yahoo mail – Change Password Gmail – Yahoo mail

June 19, 2020

Hướng dẫn cách đổi mật khẩu Gmail – Yahoo mail – Change Password Gmail – Yahoo mail —————————————————————- Gmail và...

## Hướng dẫn chơi GTA 5 Online cho người mới bắt đầu – Epic Game 2020 | Nhận Nhà, Gara | Phần 1

June 14, 2020

#huongdan #gta5online #nhiemvu Hướng dẫn chơi GTA 5 Online cho người mới bắt đầu – Epic Game 2020 | Nhận...

## NHỮNG ĐIỀU DÂN CHƠI LIÊN MINH CẦN BIẾT TRƯỚC KHI TẬP CHƠI DOTA 2 (P.1) | HƯỚNG DẪN TÂN THỦ

June 13, 2020

NHỮNG ĐIỀU DÂN CHƠI LIÊN MINH CẦN BIẾT TRƯỚC KHI TẬP CHƠI DOTA 2 (P.1) | HƯỚNG DẪN TÂN THỦ...

## DOF Preview là gì ? Sử dụng như thế nào ?

June 14, 2020

Sử dụng tính năng DOF Preview để xem trước độ sâu trường ảnh bằng kính ngắm và xem trước hiệu...

• Phelipe Carmo says:

That video saved my day hehe thank you so much leila much appreciated

• carole nisperos says:

Hello! Is there a way to use nested if in a filtered data?

• Social Sathish Rao says:

Thank you for nice explanation.
I have one query on below formula,
=IF(A3=A4&A3=A5,MAX(B3:B5),0)
Or
=IF(A3=A4=A5,MAX(B3:B5),0)

Both are giving wrong results.

• Braulio Ayala says:

EXCELLENT Demo!!!!!!

• Aanya Charles says:

but what if you need it for true and false

• seniscram says:

Awesome. You are easy to listen to. Everything is very clear. If you also teach coding and webdesign… sign me up.

• Samir Awati says:

hi madam, if numer also contain text for exmple, 10g, 300ml can we use if formula. i am trying to use but not working. i am using =IF(A1<10,"a","b"). everthing showing b. please reply madam thank you in advance

• Avinash Gupta says:

Great video. Would you also be able to throw some light on how do you insert different scenarios like
>1000<25000 – 10% discount
>25000<39500 – 20% discount
<39000 – 30% discount
With IF(AND conditions

• Mohamed Naji says:

Dears: Could you please help on this (How to calculate Cumulative sum for set of cells when we have change(s) in another cell(s), mohamed.naji@live.com Thank You

Leila, your videos are so clear and present amazing Excel capabilities that I haven't met in my 20 years with Excel. I've not yet finished this video, but I'm wondering why you didn't give C2 a name instead of referencing it as \$C\$2. I like names because they make formulas easier to read when I come back later and wonder what I was doing – such as "If (YTDRevenue > etc. Probably you discuss names in other videos that I haven't yet watched.

• Vinotha Narms says:

Hi I need to add one value to multiple time when the count is increase. Can u upload one video please

• Saugata Santra says:

I had one query mam, if i am copy pasting data from a webpage which has images and logos and then i use paste special in excel then after that sorting of the data becomes troublesome, so do you have any videos related to it?? It will be of great help to understand such functionality

• Khowaja Ghulam Sakhi SEDIQY says:

Very nice trick,
I have a question,
I extracts login/logout report of all staff and I need a code or trick to show or filter the first login and last logout record.

• Elso02 says:

Thank you so much for making this confusing function comprehensible! The manner in which you speak is also very pleasant to the ear whilst learning!

• Nick H says:

Thank You! This is exactly what i needed.

• Wunlapar Hanvittayanukool says:

Thank you for sharing

• Lucky Rathore says:

I'm glad I found you on YouTube and I've subscribed. Thanks so much!

• Lc1975 says:

Excellent…
👏👏

• Gaurav Kaith says:

HLO MAM HOW R U I WANT YOUR HELP IN EXCEL PROBLEM CAN YOU HELP ME . I HAVE VALUR BATCH NO. MFG DATE DATE EXP DATE MRP. PRODUCT NAME I WANT ALL OF THESE WORDS IN B1:B5 WHEN I WRITE A VALUE IN CELL A1

You're simply awesome

• Tee Diamond says:

Actually am new to excel world however your explanations makes difference as a result I like to learn more is any opportunity to help me

• Tee Diamond says:

Many thanks,

• Saurabh Ganguly says:

IF(((B5>\$D\$2)*(B5<\$D\$3)),\$C\$3,"")- I used this formula for >& <(15000 & 20000) example in your video, i still the same answer, Wanted to know whether this approach is robust or not?

• SWAPNIL PATIL says:

To the point…Thanks for the wonderful tutorial👍👍

• David Drew says:

I am using Excel 365 and I monitor my shares via the Shares button. How can I change it to refresh automatically

• Bimal Panchal says:

You are awesome, incomparable!

• Phuc Le says:

Excellent tutorial. Very easy to follow

• Manuel Barros says:

Very good!

• John Philippatos says:

I'm tired as hell, I know everything you showed in this video as I have used the "If" function extensively, and I still got to watch it to the end with all the attention I could manage to gather.
Thank you Leila. Stay safe.

Thanks so much for the videos you post…you have helped me so much in advancing my skills in excel!!!!!!🙏🙏🙏🙏

• ALi URMU says:

IF( YOU watch the video, "on \$ CORONA DAYS \$ ", "say Hi and \$ Click Thumbs Up \$ ")

• Josy Joy says:

Hi Leila, how to club below 3 formula's into one formula?
=IF(A1="S",B1*-1,B1)
=IF(A1="L", C1*-1,C1)
=IF(B1=0,C1,B1)

• Baatish says:

I'm starting from zero here can you please tell me what do you mean by fixing it by pressing F4 and why is it necessary.

• VENKAT IYER says:

Your explanation is too good … to be more honest now I have understood use of if(and .. if(or …. thanks a lot Mam

• Hanson Tan says:

How to use IF based on cell color with auto update without refreshing?

• Kasonde Lwao says:

Thank you! Very useful in answering exam questions

• vinit gupta says:

Hi ma'am
Thanks for teaching us.
I have a question. Could you please tell us that what's the difference between Nested if and And funtion? Both are the same firmula. Please help.

• DrinkingStar says:

Excellent tutorial. It seems that much, if not all, of this information can be used in LibreOffice Calc. I will eventually give it a try. This is the second video of yours I have watched. I am sure they all deserve a "Thumbs UP". Thanks.

• Mahedi Ferdous says:

Thank I was searching for it but you should make quick video and you should choose a good screen recorder and good video compressor

• AK KA says:

like to know how to make duplicate invoice on same page please….anyone

• BENSEDDIK Djamel says:

Thank you very much…………… you are the most amazing YouTube channel, very nice

• Smug Smugly says:

How come you can onlu do 9 nested IF statements?

• Truth Betold says:

Now how do I apply this in Concrete computations in computing for the Mu working in a Analysis problems.

• Marcelino Estebanell says:

Great tutorial Leila. You make Excel way easier. For several days I am looking for one of your tutorials (you might not have it). I have a Grocery Shopping list and I added a counter to add up each time a veggie from the list is checked in checkbox. I can`t get it to work and I can`t find one of your fabulous lessons.
Lets say, I check Apples this week so counter adds 1 (easy enough so far). But i want the counter for apples stay in spreadsheet. Next time I might not check apples for I don`t need them, but until i order again i`d like the counter to show 1 order i already made and add to counter a second order when needed. Could you please tell me where to find a tutorial for that??.
Keep up the good work.
Best regards
Marcelino Estebanell

• Daniel K says:

Is it possible to use "good", "bad", and blank if no data matches with conditions at all?

• Pablo Dompe says:

The best Excel channel in the all youtube and web!! Thank you!!!!!!!!

• Billy A says:

Best every tutorial! Thank you so much 🙂

• KH Today says:

Hello can you show me how to link comment cell to other cell ?

• Afzaal Ahmed says:

Your personality and way of teaching is very impressive

• mahbubur rahman says:

She is brilliant.