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! :-)
I would use the AND function rather than multiplying - for easier understanding by other people. Multiplication is for advanced Boolean algebra practitioners only.
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 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?
Can you do multiple options for IF when using a drop down? Drop down one would have multiple choices and based on those choices drop down two would have corresponding answers. Ex: IF "trim" is true then "Crew ONE" is true, IF "crane" is true then "Crew TWO" is true. How do you do the IF function with text only?
Hi! To achieve that, you'll need to use data validation for dropdowns. For dependent dropdowns, use IF or FILTER to match options based on the first selection. Apply validation to the second dropdown with the results. Done!
@@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 🤓
Watched this twice and feels like wanna watch it again, haha. Well done!
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 :)
Great video. Please keep up with more videos!
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! :-)
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.
We’d love to hear from you!🙋♀️💬Share your experience using the IF function in the comments ⬇️
Love the video!! Thank you!!
Keep it uuuppp!!!
👏👏👏👏👏👏
Thank you too!
NICE VIDEO, easy to understand, thanks a lot
This is awesome,thanks. I can't find link to unicode characters though
I would use the AND function rather than multiplying - for easier understanding by other people.
Multiplication is for advanced Boolean algebra practitioners only.
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 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
Can you do multiple options for IF when using a drop down? Drop down one would have multiple choices and based on those choices drop down two would have corresponding answers. Ex: IF "trim" is true then "Crew ONE" is true, IF "crane" is true then "Crew TWO" is true. How do you do the IF function with text only?
Hi! To achieve that, you'll need to use data validation for dropdowns. For dependent dropdowns, use IF or FILTER to match options based on the first selection. Apply validation to the second dropdown with the results. Done!
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