I do enjoy your videos. Is it possible that you can go back to showing teachers how they can use these functions when planning a lesson, or creating an interactive document that will give students instant feedback?
I'm trying to make a simple sheet to check questions in a test, but I can't get it right. If the question was annulled, or I didn't answer yet, it should just say "-", then, I use another IF function to tell if the question is wrong or right. It goes something like =IF(AND(ISBLANK(D2);D3="ANNULLED");"-";IF(D2=D3;1;0)) For some reason, all results are 0 and 1.
Learning a lot from you everyday. Thank you so much ❤️
I do enjoy your videos. Is it possible that you can go back to showing teachers how they can use these functions when planning a lesson, or creating an interactive document that will give students instant feedback?
Thanks alot Boss, have been struggling without knowing, it's been very informative
Extremely well explained! Thank you.
bravo very educative
Watched this and the IFS function video. Cool! I look forward if or when you’ll do a video on IF + AND. with tables or IFS + Table. 😅😅
😊😊😊
Thank you!
Excellent explanation. Thank you so much.
watching from Philippines
Thanx
Awesome videos. However, i cant seem to get the if function to work with checkboxes. any advice?
Something new I learnt today. THANKS and Subbed
I'm trying to make a simple sheet to check questions in a test, but I can't get it right. If the question was annulled, or I didn't answer yet, it should just say "-", then, I use another IF function to tell if the question is wrong or right. It goes something like
=IF(AND(ISBLANK(D2);D3="ANNULLED");"-";IF(D2=D3;1;0))
For some reason, all results are 0 and 1.
Hello I enjoy watching your channel can you tell me how can I create a random number between 20 to 39 to create five digit random number in Excel
Nicely explained
Hi, do you have serial of Ms office?
Thanks teacher
Thank you
Thanks!
Excellent tutorial, tfs
solid
Awesome!! Thanks 🙏
Brilliant 👍🏻