Timestamps to navigate through the video: 0:00 What is the IF function 0:35 The IF function syntax breakdown 0:58 The IF function basic example 2:36 How to use other formulas as IF function arguments 3:38 How to apply the AND / OR logic within the IF function 5:02 How to automatically pull and refresh data from other apps to Gsheets using Coupler.io 5:31 How to use the nested IFs (embed one function inside of another) 7:33 What is the IFS function + the syntax breakdown 8:08 The IFS function basic example 10:44 Workaround to combine the IF function with wildcard characters 12:44 Using ARRAY FORMULA with the IF function 14:29 Video summary
I came across this channel when making my project timeline. I'm a motion grapher myself, so I know how much effort you put in these videos animation, kudos! Not only the information, but also the animation, this is such high quality content. Definitely got me to subscribe :)
Very useful. Thank you! Especially the blog link to a spreadsheet with the formula inserted. This was a saviour! The IF, AND, OR is now embedded into our booking calendar! :-)
Hi, I would like to know how to get the sum with (-) negative value ie. profit/loss let say "A2-total earn" - "A3+A4" are the expenses but expenses are higher than total earn. If I do SUM and MINUS formula it doesn't show the (-). Thanks and hope my question is easy to understand.
Thanks for your question! To calculate profit/loss with a negative value when expenses are higher than total earnings, try this formula: =A2 - (A3 + A4) This will subtract your total expenses from your earnings, and if expenses are higher, it will show a negative value (loss).
I would use the AND function rather than multiplying - for easier understanding by other people. Multiplication is for advanced Boolean algebra practitioners only.
i love the style of presentation. it's classy. I guess my question is, those parentheses though. what's the syntax or the format to avoid errors? I'm tasked to identify if the NO survey result is driven by process or employee and how it impacts the resolution rate. I don't know how to do this lol help anyone?
@@DroneQuadcopter thanks. really it is not the comma, it is dot-comma(;)this info solved all the problem. Sheets has changed its coding language. thanks you for opinion
Timestamps to navigate through the video:
0:00 What is the IF function
0:35 The IF function syntax breakdown
0:58 The IF function basic example
2:36 How to use other formulas as IF function arguments
3:38 How to apply the AND / OR logic within the IF function
5:02 How to automatically pull and refresh data from other apps to Gsheets using Coupler.io
5:31 How to use the nested IFs (embed one function inside of another)
7:33 What is the IFS function + the syntax breakdown
8:08 The IFS function basic example
10:44 Workaround to combine the IF function with wildcard characters
12:44 Using ARRAY FORMULA with the IF function
14:29 Video summary
What I liked in this video: graphics, examples, explanation!
What I did not like in this video: hmmm, it seems everything was great :)
Thank you!
Thanks! It’s a very useful video. I am gonna go and practice IF formula 🤓
I came across this channel when making my project timeline. I'm a motion grapher myself, so I know how much effort you put in these videos animation, kudos!
Not only the information, but also the animation, this is such high quality content. Definitely got me to subscribe :)
This was explained so well! thank you so so much, getting multiple options on the if function was driving me insane. You're the best for this.
Watched this twice and feels like wanna watch it again, haha. Well done!
Very useful. Thank you!
Especially the blog link to a spreadsheet with the formula inserted.
This was a saviour!
The IF, AND, OR is now embedded into our booking calendar! :-)
Great video. Please keep up with more videos!
We’d love to hear from you!🙋♀️💬Share your experience using the IF function in the comments ⬇️
NICE VIDEO, easy to understand, thanks a lot
Love the video!! Thank you!!
Keep it uuuppp!!!
👏👏👏👏👏👏
Thank you too!
This is awesome,thanks. I can't find link to unicode characters though
Hi, I would like to know how to get the sum with (-) negative value ie. profit/loss let say "A2-total earn" - "A3+A4" are the expenses but expenses are higher than total earn. If I do SUM and MINUS formula it doesn't show the (-). Thanks and hope my question is easy to understand.
Thanks for your question! To calculate profit/loss with a negative value when expenses are higher than total earnings, try this formula:
=A2 - (A3 + A4)
This will subtract your total expenses from your earnings, and if expenses are higher, it will show a negative value (loss).
I would use the AND function rather than multiplying - for easier understanding by other people.
Multiplication is for advanced Boolean algebra practitioners only.
i love the style of presentation. it's classy. I guess my question is, those parentheses though. what's the syntax or the format to avoid errors?
I'm tasked to identify if the NO survey result is driven by process or employee and how it impacts the resolution rate.
I don't know how to do this lol help anyone?
Stylist video
Don't understand why it isn't working for me
same =IF(C8=C11,C12,C11) says ERROR no matter what I do, or even if I use these: =IF(C8="0","1","0")
I find it out, now it is not a comma, but ;
@@DroneQuadcopter thanks. really it is not the comma, it is dot-comma(;)this info solved all the problem. Sheets has changed its coding language. thanks you for opinion