Generally, IF is a logical function that **tests the given condition** and **returns the output according to it**. To be more precise, the Excel IF function checks whether the given condition is **True **or **False**. If it is true, then it returns the first value. In case, the given condition is False, it returns the second value. It is a built-in function in Microsoft Excel. If you want to know how to use this in your workbook, then we will help you.

Today, we will guide you to know the generic syntax, proper explanation, and a few example scenarios for **Excel IF Function**. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Syntax

- Here, you will see the syntax of the
**IF**function. - To apply this function on your spreadsheet, you must
**select a cell**and**enter the formula**in the following format. - Once you enter the formula,
**click**the**Enter**button to get the result.

**=IF(logical_test, [value_if_true], [value_if_false])**

**Parameter Description**

**logical_test –**The logical expression that needs to be evaluated as**True or False**.**value_if_true –**It is an optional one. If the given**logical test is True**, it returns this value.**value_if_false –**This is an optional one. In case, the given**logical test is False**, it returns this value.

**Note:**

1) Excel IF Function is **not case sensitive**.

2) If you input the **array as arguments** in this function, it will evaluate every element of the array.

## What will IF Function do?

This built-in feature allows you to **check whether the given condition is true or false** in the spreadsheet. Suppose you have a **student mark details** and want to categorize them as **Pass **or **Fail **based on the scores. Students who got **more than or equal to 50**, then they will come under “**Pass**“. **Else**, they will come under “**Fail**.”

You can also manually check the scores and enter the data as Pass or Fail in the worksheet. But it takes too much time to complete and there might be some possibilities of making mistakes while doing it on your own. So, we don’t have to be worried about it. Just simply use the IF function, and we can get the proper output without any mistakes or delay.

Here is the sample data sheet, where we can enter a few **students’ names and their scores** on a particular subject. Let’s see how to apply the IF Function to this data.

Now, we need to **enter the following formula** in a cell where we want to get the result in the worksheet.

After entering the formula, **click **on the **Enter **button to execute it and get the result. To **fill the remaining cells** in the range, you have to **drag down the first cell** to the last cell in the range. It will quickly autofill the results based on the given input values.

We hope that this scenario helps you understand the basic concept of the Excel IF function. If you’re still confused about using it on your worksheet, then you can refer to the following section for simple and easy examples. They will help you to understand it in a better way.

## Alternate Examples

Here we will show you a simple example to know how to apply the Excel IF function in the spreadsheet.

- Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
- For instance, we have given the random input numbers in the range
**B3:B9**. And we will get whether the given condition (**value<70**) is true or false. If it is true, then it needs to return the value as “**Yes**“, else it returns “**No**.”

- Then, you have to
**enter the formula**in the cell as shown below to get the result.

- After entering the formula, you need to
**click**the**Enter**button to get the output.

- Once you have gotten the first result, just
**drag down that cell to autofill the remaining cells**in the range, as shown in the below image.

## Conclusion

At last, we have concluded that the IF function in Excel is used to **check whether the given condition is true or false** in the worksheet. Here we have seen various examples to understand the working nature of this built-in function. Kindly give your **feedback **in the below comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.

If you want to know what people think about this IF Function of Excel, then we suggest you look for it on the Quora interaction webpage. From where you can get to know more regarding the Excel IF function. Here, we have provided the link to **Quora’s official website**: **Use IF in Excel**.

## Video Tutorial

The following video will show you the procedure to apply the IF Function and how to use it effectively in your spreadsheet.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?