AWESOME video explaining how to use the IF and IFS. I learned a lot in this video, and you do a great job of explaining step by step. I like how you show us basic and then take it to the next level. It really helped me understand the IF statement better. THANK YOU!!
Thank you. It was really uselfull, IF= i had seen this video three days ago, Now i would have saved more than 10 hours of time wasting and searching for a If Formula that i wanted to apply to my invoice. :( .
I have another question if that's ok. In example where you showed the chicken and/or steak and/or under 2 yo, you said it will not work if it's not in the right order. You said that if the first statement is true, the function will stop. But isn't the first part true as well, as in the guest is under 2 and it says "Yes"? How does that work? To me they're both true. Thanks.
I have a question for you if that's OK. I would like to have a worksheet that will contain many columns that contain dates, specifically expiration dates. Some of these columns will be side by side, and others will not, but they're all on the same sheet. Now, I would like to have specific ranges that these dates need to fall into for some kind of alert to tell me that's it's expiring soon. For example, a green cell if the date is between 60-90 days from expiring, a yellow cell if the date is between 30-60 days from expiring, etc. The date range groups will be 60-90, 30-60, 15-30, 1-15, and finally expired. I've tried using cell ranges such as $C$4:$D$50 or $E$1:$E$50 with some random formula I found online (sorry, I don't remember it off the top of my head), but it doesn't work half the time. What would be the best way to address this? Also, is there a way to activate pop-ups or something similar when a date(s) have expired instead of only filling the cell in with a color? Thank you, great video!
![[LIVE] : ONE ลุมพินี 87 วันนี้!! คู่เอก "ก้องชัย vs โชคปรีชา"](http://i.ytimg.com/vi/YN6e7HVnekw/mqdefault.jpg)
This makes excel so much easier to understand. ❤
Glad it was helpful!
AWESOME video explaining how to use the IF and IFS. I learned a lot in this video, and you do a great job of explaining step by step. I like how you show us basic and then take it to the next level. It really helped me understand the IF statement better. THANK YOU!!
Glad it was helpful!
Thank you. It was really uselfull, IF= i had seen this video three days ago, Now i would have saved more than 10 hours of time wasting and searching for a If Formula that i wanted to apply to my invoice. :( .
Amazing!!! It will definitely help me at work. Thanks!
Great summary! Concise & super informative!
Thanks man! I like your videos too!
simply explaining difficult thing in easy ways
Really loved your videos, sir. Learned a lot.
This is a great explanation, very clear and informative.
Awesome! Glad you liked it!
Can you please do a video on an alternative method for ifs… if you have a version without this function please?
Thnks very clear
Great! Glad it worked!
Thanks very good lesson:-)
Awesome! Thank you!
Is it possible for Google Sheets to add a daily interest? As in automatically add 3% daily etc etc?
I was having problems with count a sum formula I wanted to know the difference between 2 amount how much was paid and outstanding
I have another question if that's ok. In example where you showed the chicken and/or steak and/or under 2 yo, you said it will not work if it's not in the right order. You said that if the first statement is true, the function will stop. But isn't the first part true as well, as in the guest is under 2 and it says "Yes"? How does that work? To me they're both true. Thanks.
I have a question for you if that's OK. I would like to have a worksheet that will contain many columns that contain dates, specifically expiration dates. Some of these columns will be side by side, and others will not, but they're all on the same sheet. Now, I would like to have specific ranges that these dates need to fall into for some kind of alert to tell me that's it's expiring soon. For example, a green cell if the date is between 60-90 days from expiring, a yellow cell if the date is between 30-60 days from expiring, etc. The date range groups will be 60-90, 30-60, 15-30, 1-15, and finally expired. I've tried using cell ranges such as $C$4:$D$50 or $E$1:$E$50 with some random formula I found online (sorry, I don't remember it off the top of my head), but it doesn't work half the time. What would be the best way to address this? Also, is there a way to activate pop-ups or something similar when a date(s) have expired instead of only filling the cell in with a color? Thank you, great video!
I would check out my highlight due dates and expiration dates video first. th-cam.com/video/H1bEpd-i4DM/w-d-xo.html
@@whyworksmarternotharder Thank you so much!