The Perform Conditional Operations Using Functions module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Perform Logical Operations using IF and SUMIF

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Perform Logical Operations using IF and SUMIF

Decision-making functions test a logical condition, then return a value or take an action. For example, you might want to know the sales figures that result if a certain condition is true. Excel has many functions, such as IF, AND, and SUMIFS, that evaluate conditions before returning a value.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.