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.
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.
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?
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.
Really easy to follow. Thanks so much!
You're so welcome!
Love your lectures. Straight forward and easy to understand.
Thanks, Chris! Much appreciated.
very straight fwd and direct. love it
Thanks Chris you have saved our university coursework!!
Good to know. Thanks, Rachel!
super helpful thanks sir !!!
Most welcome!
Thank you, Chris Menard!
Glad to help! Thanks, RM.
Amazing syntax!! works great
Thank you.
It's very useful lesson, Thank you,
You are welcome!
this really helped, thanks
THANK YOU SIR.🙏🙏
Most welcome
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.
My hero!!!😊
Love it. Thank you.
easy to understand!
Thank you,
It would be nice if Exercises Files were uploaded. Thanks
Thank you! Any tips on how to become a master excel user?
great,. thanks
Welcome 😊
I like your clip it’s awesome
You are welcome.
Thanks
Welcome
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?
yes. here is a screenshot I made for you. drive.google.com/file/d/1ax5lGPKJEHCf51vuQ6S19uiAB8E8KdG9/view?usp=drivesdk
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.
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?
Here is an animated GIF with one IF based on another IF. drive.google.com/file/d/1dRY0RebK9vt-FDCUK5cOw85mtH3eeyGm/view?usp=sharing
You're the best!
Thanks, Kwasi.
I DIDNT UNDERSTAND THE LOGIC OF THIRD EXAMPLE WHERE YOU COMBINE BOTH FUNCTIONS IF OR/AND
This was great, but I keep getting an empty cell. Can you please let me know what I am doing wrong? Thx
Did you get it right
thks bro.but without the file....😢
Good effort but not friendly.Basically want to understand when and why IF @ OR to use.
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.