Рет қаралды 47,233
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...
🔃To automatically pull your data from various apps to Google Sheets, use Coupler.io: bit.ly/coupler-... (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-...
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