WHAT IS FORMULA MS EXCEL |FULL DETAIL ITS EXTRA KNOWLEDGE

What is IF Formula in MS Excel (What is IF Formula in MS Excel?)

What is the IF Formula in MS Excel? Microsoft Excel is widely used for data analysis, calculations, and reporting in almost every field, large or small, around the world. It is a powerful tool that comes with MS Office.

We find many functions or formulas in MS Excel, among which the IF formula stands out as one of the most essential and versatile features. The IF formula allows users to apply logical tests to data and perform various actions based on the results. In this article, we will learn what the IF formula is and try to understand it with practical examples. So, without further ado, let’s get started.

What is IF Formula?

What is IF Formula in MS Excel – The IF formula in MS Excel is a conditional function, used to determine a condition. This function uses a user-defined condition to test values, which evaluates a logical test, returning one value if true and another value if false. Its syntax is as follows:

In the above syntax, logical_test is the condition that Excel checks for truth or falsity. This means that here we take the condition against which we want to check the value.

In value_if_true, we define the condition for the task to be performed if the value in the cell is true. This means that the result should be displayed when the condition is met.

Finally, in value_if_false, we define the condition for the task to be performed if the value in the cell is false. This means that the result should be displayed if the condition is not met.

Example 1: Basic IF Formula

have failed. That is, students whose score is greater than or equal to 60. To understand the IF formula, let us take a simple example. Suppose we have a list of scores of some students in column ‘A’, and we want to determine which students should be shown as passed or not based on their scores.

And students with scores less than 60 are to be marked as failed. To perform this task, we will use the IF formula in column ‘B’, as shown in the image below:

After entering the formula =IF(A2>=60, “Pass”, “Fail”), press the Enter key. The result will be displayed. If you want to see other results as well, drag the corner of cell B2 down to cell B4. This will display the results in all cells, as shown in the figure below:

In the above example, logical_test is A2>=60, which checks whether the score in cell A2 is greater than or equal to 60. If test is True, value_if_true will display “Pass”, and if test is False, value_if_false will display “Fail”.

As a result, the formula in cell B2 will display a “Pass” result because 85 is greater than 60. Similarly, cell B3 will display a “Pass” result because 72 is greater than 60, and cell B4 will display a “Fail” result because 45 is less than 60.

Nested IF Formula

IF formulas can be nested, meaning that when we need to calculate results based on multiple conditions in a data set, we use the IF function multiple times within a single formula. This process is called a nested IF formula. Let’s understand the use of nested IF with an example:

Example 2: Nested IF Formula

To explain this function, let’s continue with Example 1 above to make it easier for you to understand. Let’s assume we now want to grade students based on their scores. That is, students with scores greater than or equal to 90 will be graded.

We want to give them an “A” grade, those with a score greater than or equal to 80 a “B” grade, those with a score greater than or equal to 70 a “C” grade, those with a score greater than or equal to 60 a “D” grade, and those with a score less than 60 an “F” grade. To perform this task, we will use the Nested IF formula in column ‘C’, as shown in the image below:

After entering the formula, press the Enter key. The Grade will be displayed. If you want to see the remaining Grades as well, drag the corner of the cell located at C2 down to cell C4. This will display the Grades in all the cells. As shown in the figure below:

In this example, we have written the nested IF formula as,

=IF(A2>=90, “A”, IF(A2>=80, “B”, IF(A2>=70, “C”, IF(A2>=60, “D”, “F”)))) Since in the above example 4 conditions are given to calculate the grade, hence here we have used IF formula 4 times.

As a result, the formula in cell C2 will return a “B” grade because 85 is greater than 80. Similarly, cell C3 will return a “C” grade because 72 is greater than 70, and cell C4 will return an “F” grade because 45 is less than 60. This is how you can use multiple IF statements in Excel to satisfy multiple conditions.

You learned –

In this article, “What is the IF formula in MS Excel,” we learned the IF formula and its basic syntax. We also used examples to explain how to use it in Excel. We also tried to explain the Nested IF formula in very simple terms with examples.

We hope you enjoyed our article on “What is IF formula in MS Excel” and learned something new. If you enjoyed this article, please share it with your friends. If you have any questions or suggestions, please comment. Thank you!

• Free MS-Excel Course Tutorials For Beginners

• Review and View tab in Excel | Its Features

• What is the function of the data tab

• How to Save and Cut MS Excel Workbook