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:
- 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])
- 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.
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.
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.
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.
The following video will show you the procedure to apply the IF Function and how to use it effectively in your spreadsheet.
- 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?