SkillSoft Explore Course – Lambers, Inc.

Collections Essentials Google Sheets (No Assessments)

Conditional formulas let you perform a calculation on a range of values by specifying criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Goggle Sheets.

Asset ID	ds_gshee16_11_enus
Course Type	Video Course
Course Category	Essentials

Objectives
Google Sheets: Conditional Formulas Using conditional formulas Inserting a conditional sum formula Creating multiple conditions Performing complex conditional formulas Using IF & OR in conditional formulas Using reference positions in conditional formulas Keeping your table up to date with conditional formulas Viewing data in different languages Creating a multi-language version of your worksheet

Objectives

Google Sheets: Conditional Formulas

Using conditional formulas
Inserting a conditional sum formula
Creating multiple conditions
Performing complex conditional formulas
Using IF & OR in conditional formulas
Using reference positions in conditional formulas
Keeping your table up to date with conditional formulas
Viewing data in different languages
Creating a multi-language version of your worksheet