From the course: Google Sheets Essential Training
Join today to access over 24,400 courses taught by industry experts.
Using IF and nested functions in formulas - Sheets Tutorial
From the course: Google Sheets Essential Training
Using IF and nested functions in formulas
- [Instructor] The IF function in Google Sheets allows you to evaluate the contents of a cell for two possible conditions and calculate a value to return depending on whether the result is true or false. Let's review how the IF function works in Google Sheets. Let me show you how on this sales spreadsheet. Click on a cell and enter the IF function by entering an = and typing the word IF. I want to do a logical test on cell D2 to see if there's enough items left in stock for next month. I'll put my formula in this cell Cell H2 =IF, and I'll select the IF function from the dropdown that appears, I'll select cell D2, under amount left in stock, and type the equation <10 for my logical expression. Next, I'll type a comma as shown in the syntax of the formula below. Next, I'll enter the value I'd like to return in cell H2 if the outcome of the test is true. I'd like it to display the words order more in the cell if there are less than 10 items left in stock. So I'll enter the text, order…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
