Thank you so much!!! Finally I got all of the IF function, not only IF. Before I couldn't get the difference between the first range and the last range in the formula!!!
Hi Mike. Since the IFS version of the CountIF, SumIF, AverageIF are more versatile, would it matter in the exam if one chooses to use , say, SumIFs, instead of sumIF?
You’re actually correct. They are more versatile and if you were doing the Expert exam it would be the IFS variations. But I wanted to save that one for the big bad advanced formulas tutorial at the end haha
Be aware that Datedif requies +1 at the end of formula to be accurate. If you subtract days form end of april and beggining of april you will have 29 days not 30.
I got 957 points when I tried the exam first time. It's all because of you. Thanks, Mike.
That’s a great score, Subarna! Well done! I’m glad these videos can help.
Thanks for the crash course! Understood this more than how my teacher explained it to me
Thank you so much!!! Finally I got all of the IF function, not only IF.
Before I couldn't get the difference between the first range and the last range in the formula!!!
Hi Mike. Since the IFS version of the CountIF, SumIF, AverageIF are more versatile, would it matter in the exam if one chooses to use , say, SumIFs, instead of sumIF?
You’re actually correct. They are more versatile and if you were doing the Expert exam it would be the IFS variations. But I wanted to save that one for the big bad advanced formulas tutorial at the end haha
Why you private excel crash course and practise exam videos ):
Lots of love from Nepal ❤❤❤❤❤❤❤❤❤❤❤❤❤
Which function in the video are you most likely to use?: Countif, IF, Averageif, Sumif, or Datedif?
IF function
Be aware that Datedif requies +1 at the end of formula to be accurate. If you subtract days form end of april and beggining of april you will have 29 days not 30.
IF Functions
thats the video. what's the point of your comment
@@medicalsupplycenter1079 just made a note