How to Use an IF Function with Range of Values in Excel

In this tutorial, you will learn how to use an IF function with a range of values in Excel.

One of the most used functions in Excel is the IF function, which enables you to compare values logically to expectations. Thus, an IF statement can produce two outcomes. If your comparison is True, the first result is what you get; if it’s False, the second.

Once you are ready, we can start by using real-life scenarios to help you understand how to use an IF function with a range of values in Excel.

IF function with Range of Values in Excel

Before we begin we will need a group of data to be used to use an IF function with a range of values in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to know the grades for all students if they failed or pass by seeing the exam marks they have gotten. To do so, we can simply use the IF function in a formula like this =IF(B2>39,”Pass”,”Fail”).

Step 3

Once you press Enter, your formula will return the grades for all the students.