IF, IFS, Nested IFs Functions in Google Sheets ✅ Simple Tutorial with Examples

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: http://bit.ly/practice-rwif

🔃To automatically pull your data from various apps to Google Sheets, use Coupler.io: http://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 http://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