Conditional functions and logic

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

Analyzing data

  • Chapter 1: Exploring data

  • Chapter 2: Cleaning and preparing data

  • Chapter 3: Analyzing data

 

The data analysis process, with the analyzing data stage highlighted.

Data Analysis in Google Sheets

Conditional functions

  • Conditional functions: return different results depending on criteria

A high-level summary of the logic we used to determine whether to wear a coat.

A person walking a dog. Both the person and dog are wearing coats.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

The IF() function

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Logical functions - AND()

Syntax:

AND(logical_expression1, [logical_expression2, ...])
  • Returns TRUE if all logical expressions return TRUE

 

Example:

= AND(3 > 2, 1 < 2)

TRUE
Data Analysis in Google Sheets

Logical functions - OR()

Syntax:

OR(logical_expression1, [logical_expression2, ...])
  • Returns TRUE if at least one logical expression returns TRUE

 

Example:

= OR(3 > 2, 1 > 2)

TRUE
Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Combining IF() and AND()

Syntax:

IF(logical_expression, value_if_true, value_if_false)

Analyzing startup pledged funds versus goal funds.

Data Analysis in Google Sheets

Let's practice!

Data Analysis in Google Sheets

Preparing Video For Download...