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