Excel: IF function combined with AND and OR functions by Chris Menard

preview_player
Показать описание
Advanced IF functions using the OR function and the AND function.
My video on the IF function for Administrative Professional Day Conference

Covered in this video is IF with AND and OR.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
  1. Chris Menard
  2. IF
  3. AND
  4. OR
  5. Function
  6. Excel
Рекомендации по теме
Excel: IF function 0:06:44

Excel: IF function combined with AND and OR functions by Chris Menard

Excel IF Formula: 0:15:23

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

How to use 0:03:36

How to use the IF function in Excel

Excel Tutorial - 0:05:51

Excel Tutorial - Multiple conditions within an IF function

IF Function in 0:06:14

IF Function in Excel Tutorial

How to use 0:07:35

How to use the If and Vlookup functions together in Excel

Excel If Formula 0:20:30

Excel If Formula - Nested If AND OR Functions

Excel if function 0:00:48

Excel if function | Excel if formula | Excel if formulas and functions | Excel if statements

How to Use 0:00:55

How to Use Index & Match Function in Excel with Multiple Criteria | Excel Formula Hacks

Excel Logical Functions 0:08:05

Excel Logical Functions - IF, AND, OR

MS Excel - 0:07:15

MS Excel - IF Function

Excel: IF Function 0:10:01

Excel: IF Function MULTIPLE CRITERIA | IF ELSE Function | Nested IF Function

Excel IF Function 0:06:37

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

IF Formula in 0:10:37

IF Formula in Excel With Multiple Conditions | If Else Statement in Excel | Nested IF And Or

Building 'If-Then' Statements 0:03:49

Building 'If-Then' Statements in Excel : Advanced Microsoft Excel

MS Excel - 0:02:39

MS Excel - Nested IF

Excel Logical Functions 0:05:26

Excel Logical Functions IF, AND, OR

How to Use 0:11:01

How to Use the IFS Function in Excel

Excel IF Explain 0:06:24

Excel IF Explain in Brief || Excel IF AND function || Excel IF OR function

Everything You Need 0:18:29

Everything You Need To Know About The If Formula In Excel

IF statements with 0:03:12

IF statements with VLOOKUPs -- Microsoft Excel

All 3 Excel 0:09:01

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

Become Excel Master 0:07:55

Become Excel Master With 7 Useful IF Formula Examples - Excel Formula and Functions - IF Function

How to use 0:01:07

How to use the IF function in Excel

Комментарии
Автор

Love your lectures. Straight forward and easy to understand.

chrisyuen
Автор

Thanks Chris you have saved our university coursework!!

rachel
Автор

It would be nice if Exercises Files were uploaded. Thanks

shoppersdream
Автор

i have a question, im using the result of the vlookup which is blank. Im making a new formula in another cell using the result and using the "if" formula for the value, what condition should i use?

jayveecahambing
Автор

Is it possible we can make the fomyula the other way round. If and or, like you can attend training and score 625k or attain 700k?

CollinsOtieno-eldj
Автор

This was great, but I keep getting an empty cell. Can you please let me know what I am doing wrong? Thx

LilyDay-dfwf
Автор

Excel.
Year B9= 2012
Less than E8= 70000
Or less than G8= 105000


Answer this please im struggling

Add OR function in cell H9 that will display the true function if cell B9 is less than cell E8 or less than cell G8 or otherwise display false.

moustafaalbatran