Комментарии:
Great but I would like ask about $ sign front of E2 why E2 dosnt have value for $ only F2 Thank you sooo much
ОтветитьGreat explanation. Thank you.
ОтветитьGood, please I need a note in excel
ОтветитьSir, Thank you so much. It helps me a lot to understand the function very well.
ОтветитьEasy to understand,
ОтветитьWHY can't I find a single video of someone showing how to do "if this cell contains this text then insert another value in this cell?
Ответитьthanks
ОтветитьThank you so much. You’re such a great 👍 teacher. God bless you
Ответитьthank you sir professor
ОтветитьThank you so much for creating these exercises. They are very helpful. I am literally on your channel every single day 😁
Ответитьmine is a yes or no instead or greater than less than
ОтветитьThank you for your knowledge. How can I create a formula for the following: IF data in cell A1 reads BAW-TCH-TIS, how do I have cell B1 equal cell A1, minus the first 4 letters or numbers? For example cell A1 reads BAW-TCH-TIS. Cell B2 should read TCH-TIS. I have 6,000 rows of data that I must remove the first 3 letters and the dash. Any assistnace would be greatly appreciated.
ОтветитьNew student here 😅
Ответитьthanks, can you show how to make colors change in cells depending on if statements
ОтветитьCan we avoid the nested if by using the ifs?
ОтветитьI'm really doing great will the excel tutorials. Simple and precise. Please help with the an if function for names. Example;
=IF(P10="Sir.Jamie","000001-great",IF(P10="Sir.Mike","000000-good",IF(P10="Sir.John","000015-normal",""))).
Thank you.
If any sale in column C is $1200 same as cell f1 it displays Bad month.
ОтветитьGOOD
ОтветитьThank you, sir, for posting another very useful lesson. Keep up the good work. Again, thank you so much.
ОтветитьAnd why does this doesn't have more veiws
ОтветитьYoo it was very well explained. Iam now staring to get it a bit 😅
ОтветитьShout-out to Jamie Sir. An incredible teacher for us who walked through us so easily through the lessons of Count IF, Count IFS, Sum IF, Sum IFS, and IF function and many more lessons sir. I really like your teaching and the way you speak it seems you're explaining me right in front of me . Thanks again Sir.
Love from Muscat, Oman 🇴🇲
i could not find they key to add dollar sign to add on both side of the cell id. i pressed f4, shift+4 and many more but could not. can you please help me find if you know?
ОтветитьHello
Ответитьthank you teacher for another useful lesson
ОтветитьYou are such a great teacher. I’m so glad you have these available for free here. If I were you, I’d be making money somehow off teaching others. You probably already are. Just saying. You’re good enough!!!
ОтветитьYOU . . . are an excellent instructor.
ОтветитьCan I ask why my laptop (HP), F4 doesn't come with $ (absolute value)? Thank you,
ОтветитьYou are an excellent teacher! Thank you for developing some of your time on teaching online!
ОтветитьGreat video as always!
ОтветитьWhy didn't you use the quantity column for explaining two if conditions?
ОтветитьHi
ОтветитьThank you, sir, for posting another very useful lesson this time. Keep up the good work.
ОтветитьYou screen is not visible try to enlarge
ОтветитьAnother great tutorial as always Jamie!
Thanks for sharing,
Cheers
Thanks Jamie, excellent demonstration of the IF function. More like this please.
ОтветитьThanks 😊🙏alot 😘
Ответить🌟 😻 Meow 😻 🌟
Ответить👽¡Greetings from Mars!👽
Ответитьthanks this helped alot
Ответить