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.