IF, IFS, Nested IFs Functions in Google Sheets ✅ Simple Tutorial with Examples
ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 2024
- Watch this step-by-step IF function tutorial for Google Sheets by Railsware Product Academy. In this video, you will learn:
✅ the IF and IFs functions basics (with real examples)
✅ how to combine the IF function with other functions
✅ how to nest one IF function inside of another for multiple conditions (nested IFs)
✅ the workaround to use wildcard characters inside of the IF function
📝To follow along, make your copy of a bonus 🎁practice sheet: bit.ly/practice-rwif
🔃To automatically pull your data from various apps to Google Sheets, use Coupler.io: bit.ly/coupler-rw-if (the tool shown at 5:03)
Timestamps:
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 bit.ly/coupler-rw-if
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
We’d love to hear from you!🙋♀️💬Share your experience using the IF function in the comments ⬇️
To not miss out on our next video about the ARRAYFORMULA function in Google Sheets, make sure to subscribe and hit the bell button to enable notifications 🔔
Design and video production: Oleg Gorovoi, Vlad Shagov, Karina Plastun
Cases: Natalia Gorovaia
Speaker: Karina Plastun
#IFfunction #IFGoogleSheets #IFfunctionMultipleConditions
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 🤓
We’d love to hear from you!🙋♀️💬Share your experience using the IF function in the comments ⬇️
Watched this twice and feels like wanna watch it again, haha. Well done!
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.
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! :-)
Great video. Please keep up with more videos!
NICE VIDEO, easy to understand, thanks a lot
Love the video!! Thank you!!
Keep it uuuppp!!!
👏👏👏👏👏👏
Thank you too!
I would use the AND function rather than multiplying - for easier understanding by other people.
Multiplication is for advanced Boolean algebra practitioners only.
This is awesome,thanks. I can't find link to unicode characters though
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