From the course: Google Sheets: Advanced Topics

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Using IF and IFS to analyze data

Using IF and IFS to analyze data - Google Sheets Tutorial

From the course: Google Sheets: Advanced Topics

Start my 1-month free trial Buy for my team

Using IF and IFS to analyze data

“

Imagine an On The Rise regional sales manager wishes to quickly see which store is exceeding its sales goals and which is not by looking at the sales to date in a Google Sheet. The sales manager has a spreadsheet with several columns City, State/Province, Country, Region, Month, Product, Sales - Actual, Sales - Forecast and Sales to date. The manager adds a 10th column goal status and creates a formula using the if function to display when a store is exceeding their sales goal or when they have missed their sales goal for the first six months as shown in the sales to date column, column I. Our first sales to date total is shown for Bogota, Colombia in cell I37. So let's add our formula to cell J37. The formula is written as =IF(I37> 150,000, "Exceeded Goal", " Missed Goal") Let's break down the formula to get a better understanding of how it will work. After calling the if function, the formula references cell I37, which contains the sales to date year to date result for the first…

Contents