IF Function in Excel – Free Explanation with example

IF-Function-in-Excel-Explanation-with-example
IF-Function-in-Excel-Explanation-with-example

IF Function in Excel: –

The “IF” Function in Excel is a logical test, representing the result in two ways if the logical condition is true and false. There is always two way of getting the value, one is when we got our condition/logic true and another we will get when the condition/logic false. We can use this formula where we want to apply the condition of less than, greater than, and equal to. It means if the selected cell’s value is less than a specific amount, then answer the specific true value(it may be in numeric or in words) rather than answer the false value.

The feature of the “IF” function: –

  • With the help of the IF Function, we can retrieve the data if the condition is cleared by the data.
  • VLOOKUP and HLOOKUP shows only matched value but the “IF” function shows the value in both ways.
  • It helps in applying a particular condition to the data.

The logical operator: –

We can use the “IF” function only to follow a logical test on the selected array.

Logical Test Meaning 
=Equal to
<>Not Equal to 
>Greater than 
>=Greater than and Equal to 
<Less than
<=Less than and equal to

Explanation of Function:-

Now, We will explain the Arguments of the Function.

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

logical_test:- The Logical test is the value or condition which will provide us with the result of the selected cell as true or false. It is a specific condition/test as explained in the above table.

value_if_true: – The value if true is that value which you want to show if the condition or logical test is true.

value_if_false: – The value if false is that value which you want to show if the condition or logical test is false.

Example of Function: – 

In the following table, we want to retrieve the result of all students in the Pass and Fail Form. The minimum passing marks are 70.

Example of IF Function

Solution:-

We will Apply the if function and get the result. This is shown in the following steps: –

Step No. 1:-

We will write the “=if( ” in the column of the result.

Example of If Function - Solution Step no. 1
Example of If – Solution Step no. 1

Step No. 2

Now select the cell on which you want to apply the logical test. and then write the logical test

Example of If Function - Solution Step no. 2
Example of If – Solution Step no. 2

Or if can by selecting the cell where the value of logic is written and then fix this cell by adding “$” signs.

Example of If Function - Solution Step no. 2 - second way
Example of If – Solution Step no. 2 – the second way

Step No. 3: –

Now, write the answer which you want if the condition show when the condition is true. Write the answer in t invited comma.

Example of If Function - Solution Step no. 3

Example of If – Solution Step no. 3

Step No. 4: –

Now, write the answer which you want if the condition show when the condition is false. Write the answer in t invited comma.

Example of If Function - Solution Step no. 4
Example of If – Solution Step no. 4

Step No. 5: –

Now, Copy and paste the function in all remaining cells to get the result.

Example of If Function - Solution Step no. 5
Example of If – Solution Step no. 5

Thanks 

Please Share and write your feedback in the comment box.

to buy Microsoft Excel Click Here.

Also, Check out the following function of excel: –