From the course: Google Sheets Essential Training (2021)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using IF and nested functions in formulas

Using IF and nested functions in formulas - Google Sheets Tutorial

From the course: Google Sheets Essential Training (2021)

Start my 1-month free trial

Using IF and nested functions in formulas

“

- The if function in Google sheets allows you to evaluate the contents of a cell for two possible conditions and calculate a value depending on whether the condition is true or false. Let's review how the if function works in Google sheets. Let me show you how to use the if function on this sales spreadsheet. This file is called if functions and you'll find it in the exercise files chapter six folder. Click on a cell and enter the if function by entering that equal sign and typing if. I'd like to do a logical test on cell D two to see if there are enough items left in stock for next month. I'll do a test on the value in cell D two to see if there are less than 10 items left in stock. I'll select the if function from the dropdown list that appears. I'll select D two, the amount of items left in stock for that item and type the equation less than 10 for the logical test on the contents of that cell. I'll type the comma…

Contents