Performing Conditional Calculations in Google Sheets 2020


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Conditional formulas let you perform a calculation on a range of values by specifying the criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Google Sheets. In this course, you will also learn how to use conditional formulas to translate data or to keep your information up to date.



Expected Duration (hours)
0.6

Lesson Objectives

Performing Conditional Calculations in Google Sheets 2020

  • use conditional formulas with multiple criteria
  • build a conditional sum formula
  • create a conditional formula to display specific messages
  • create conditional formulas to display and calculate values
  • build conditional formulas with AND and OR functions
  • translate data using conditional formulas
  • use MATCH and OFFSET functions to find specific values
  • use COUNTA and OFFSET functions to keep a table up to date
  • use SUMPRODUCT function to create automatic reports
  • Course Number:
    ds_gshee20_13_enus

    Expertise Level
    Expert