Performing Conditional Operations Using Functions
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.
Already have an account? Sign In »

Introduction
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.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.