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.

Download the workbook here:

Links to related videos:

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:

Time Stamps:

00:00 When to use the Excel IF function

00:35 When to use a Nested IF formula

00:55 Excel IF THEN formula

03:18 Excel IF formula with AND condition

05:05 Nested Excel IF formula

07:52 Excel IF formula with OR condition

09:17 Excel IF formula with threshold

11:22 Excel IF formula with symbols for result

14:29 Wrap-Up of different uses of Excel IF function

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:

Twitter:

LinkedIn:

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://batdongsanvingroup.vn

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

### Xem thêm Bài Viết:

- Tai nạn đường thủy 2 người chết: Quán nhậu không phép, ca nô không đăng ký
- Lật canô đi kiểm tra sà lan chở cát, một đại úy cảnh sát mất tích
- Cảnh sát giao thông gặp nạn mất tích: ‘Hai đứa con mỏi mòn chờ bố’
- Tìm hiểu về phương pháp in chuyển nhiệt trên vải
- Giải mã ý nghĩa của hiện tượng con trai mắt trái giật hên hay xui

Thank you

thank you

Hey Leila. I wonder if you can help me.

7am to 7pm is considered standard hours (4 hours is considered 1 session) and 7pm to 7am is considered premium hours (3 hours is 1 session)

After Friday 5pm upto Monday 09:00 am is premium hours (3 hrs is one session)

Week-1

Mon – 08:00 to 18:00

Tue – 15:00 to 22:00

Wed – 21:00 to 09:00

Thu – off

Friday 09:00 to 15:00

Sat off

Sunday 08:00 to 14:00

How to put a calculator in excel to work out number of sessions week-1 ?

I am struggling to put the calculator together for this work pattern.

Many thanks in advance

Amazing!!!! I learned more about if, and, or in 15 minutes than I have in months of classes. Maybe you can help with a problem I am having, I'm trying to set up a cell with an if function to reference the answer from another if function in a different cell?

I’ve been writing long if functions and not use “and” and “or” logical tests. I must say that your way of writing it is so much simpler and easier. Thank you so much!

Absolute bliss watching the functions. Great teacher.

fantastic way to explain. great job

Hi mam i have create vlookup but I have same work order with different labour cost and I need to create next sheet with vlookup search and I want all labour cost with same project number..

Hi Guys..Need help with a formula…My Formula in Words 🙂 ! If the value in a cell(B6) in 'July 2020' sheet is greater than "0" copy/transfer certain data from "July 2020" to the next sheet ('August 2020(Obviously into multiple cells ) Hope someone can help me!

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

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

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.

Could you please suggest…

EXCELLENT Demo!!!!!!

but what if you need it for true and false

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

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

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

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.

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

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

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.

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!

Thank You! This is exactly what i needed.