Is there a way to have multiple conditions in a single if command? For example, am I able to have the exact same thing as this video but have it say "200" as the bonus if they have over 900 sales? If so, how?
You can test multiple conditions by doing: =if(AND(condition1, condition2), value if true, value if false) You can give multiple outcomes by using a nested if like this: =if(sales>900, 200, if(sales>700, 100, 0) )
hey! thank you so much for the help me so quick bro but there is one problem still i didn't trying a lot of practice man soon insha'allah i will try lol
Understand that some people must utilize their time wisely, and rambling about off tangents is discouraging many viewers from watching as this video could have been shortened to 3 minutes.
Ur the best teacher ever! Clear speaking and very understandable.
Btw my igcse for ict prac is 2morrow. Wish me luck everybody.
Thank you so much! I've got my exam tomorrow and i was totally freaking out. This helped me alot.
Great video!! thank you... did you have one with Multiple conditions formulas?
Now I learned a lot thanks... need more video about excel formulas
VEry practical learning skills you possess... nice 1 me like!
Can the test or condition itself be Y or No? For example if drop down box reads yes then cell A,1. If no then B1..
it was very effective and properly explained....thank you
Thank you so much! Helpful and very clear!
Is there a way to have multiple conditions in a single if command? For example, am I able to have the exact same thing as this video but have it say "200" as the bonus if they have over 900 sales? If so, how?
You can test multiple conditions by doing: =if(AND(condition1, condition2), value if true, value if false)
You can give multiple outcomes by using a nested if like this: =if(sales>900, 200, if(sales>700, 100, 0) )
in a given years list how to find leap year and ordinary year and divide leap year with 365 and ordinary year with 355 in excel? can you help
Thank you, Madam for your explanation it was quit clear
THANKS A MILLION! YOU SAVE MY LIFE!!!! GOD BLESS U!
Thanks a lot, more videos please!
Thank You....
Nice Explanation Dear...
Can u please be my teacher i got exam tomorrow and I did half of it today and the if function I tomorrow u made my night less stressful
Thanks so much! This was very helpful! Keep on keeping on :) God Bless
Really helpful tutorial.
thanks madam you explained it so well
hey! thank you so much for the help me so quick bro but there is one problem still i didn't trying a lot of practice man soon insha'allah i will try lol
easy and useful , thank youuuu
i think it is most lovely explain for if statment especial writing beyond vido
That was clear. Thanks !
Thank you for your Video
Thank you so much :)
thank you, thank you, thank you!
I like your accent.
u blacked off the sides of the screen and expect us to see the sides when you say something ?
The way you say "sales" is almost the same as when you say "cells".
ty alot!
Understand that some people must utilize their time wisely, and rambling about off tangents is discouraging many viewers from watching as this video could have been shortened to 3 minutes.
EXCELENT THANKS A LOT
talk too much but useful
Thank you 💗💗💗💗
thank you so much
Why do not purchase a good quality camera
Yes thnxx
thankuuuuuuuuuuuu sooooooooooooooooo muchhhhhhhhhhhhhhhhhh
yes it was understanding
helpful
Thanks for your great video!
Kathy
2educateyou
She talks to much and doesn't do enough work.
EXCELlent?
helpful