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

Advanced IF functions using the OR function and the AND function.
My video on the IF function for Administrative Professional Day Conference
• Getting started with I...
Covered in this video is IF with AND and OR.
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZbin keyword search - TubeBuddy - www.tubebuddy....
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!

[@chrisyuen2968]

Love your lectures. Straight forward and easy to understand.

[@ChrisMenardTraining]

Thanks, Chris! Much appreciated.

[@rachel5342]

Thanks Chris you have saved our university coursework!!

[@ChrisMenardTraining]

Good to know. Thanks, Rachel!

[@nightwing7950]

very straight fwd and direct. love it

[@ThesaUdoh]

Really easy to follow. Thanks so much!

[@ChrisMenardTraining]

You're so welcome!

[@rmmccarthy1240]

Thank you, Chris Menard!

[@ChrisMenardTraining]

Glad to help! Thanks, RM.

[@fireflies15]

Amazing syntax!! works great

[@ChrisMenardTraining]

Thank you.

[@MasumaKasim]

super helpful thanks sir !!!

[@ChrisMenardTraining]

Most welcome!

[@AhmedEmhmed-sp9fd]

It's very useful lesson, Thank you,

[@ChrisMenardTraining]

You are welcome!

[@ikramzamri]

Thank you for the lesson❤ If I might add, i would fill the bonus amount in a separate cell and make the formula refer to that cell so that I can adjust it in future easily.

[@caitlin1316]

this really helped, thanks

[@harsinchh4342]

THANK YOU SIR.🙏🙏

[@ChrisMenardTraining]

Most welcome

[@baldybro1186]

Thank you! Any tips on how to become a master excel user?

[@shoppersdream]

It would be nice if Exercises Files were uploaded. Thanks

[@RA-rh5lb]

I DIDNT UNDERSTAND THE LOGIC OF THIRD EXAMPLE WHERE YOU COMBINE BOTH FUNCTIONS IF OR/AND

[@cheryllin4079]

easy to understand!

[@ChrisMenardTraining]

Thank you,

[@troyajohnson26]

I have a question. So in my IF AND formula, I have 4 logical tests and have a value if true statement that fits what I want. My question is, is it possible to also extend the formula to have a separate set of IF ANDs that will give me another value if true statement? Essentially having a nested IF AND formula. Effectively, if one specific logical test meets a different requirement (but the other 3 stay the same), I want my value if true to say something different.

[@gwyndolyncarver1984]

My hero!!!😊

[@ChrisMenardTraining]

Love it. Thank you.

[@aunairaun]

I like your clip it’s awesome

[@ChrisMenardTraining]

You are welcome.

[@CollinsOtieno-el7dj]

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?

[@ChrisMenardTraining]

yes. here is a screenshot I made for you. drive.google.com/file/d/1ax5lGPKJEHCf51vuQ6S19uiAB8E8KdG9/view?usp=drivesdk

[@mwatch]

Thanks

[@ChrisMenardTraining]

Welcome

[@marilubadillo8108]

great,. thanks

[@ChrisMenardTraining]

Welcome 😊

[@bijoudeaux1]

I understand the first two examples but for the third one, where you use IFOR and AND, I thought you would have done =IF(OR(F4>B1,G4=E1), 500,0) and then continue with the function to show us to use "AND". I'm completely lost. I think this part is probably for more advanced users. I realise I'm not the only one who doesn't follow the logic of what you did. But otherwise, great video.

[@jayveecahambing3432]

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?

[@ChrisMenardTraining]

Here is an animated GIF with one IF based on another IF. drive.google.com/file/d/1dRY0RebK9vt-FDCUK5cOw85mtH3eeyGm/view?usp=sharing

[@LilyDay-df5wf]

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

[@fanta.k.camara6537]

Did you get it right

[@gauranggshah7135]

Good effort but not friendly.Basically want to understand when and why IF @ OR to use.

[@kwasidzah1457]

You're the best!

[@ChrisMenardTraining]

Thanks, Kwasi.

[@tanveerabbas3271]

thks bro.but without the file....😢

[@moustafaalbatran5304]

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.