Performing Conditional Operations Using Functions

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.