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.
|<>||Not Equal to|
|>=||Greater than and Equal to|
|<=||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.
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.
Step No. 2
Now select the cell on which you want to apply the logical test. and then write the logical test
Or if can by selecting the cell where the value of logic is written and then fix this cell by adding “$” signs.
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 – 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.
Step No. 5: –
Now, Copy and paste the function in all remaining cells to get the result.
Please Share and write your feedback in the comment box.
to buy Microsoft Excel Click Here.
Also, Check out the following function of excel: –
- How to use VLOOKUP in Excel – free explanation
- How to use HLOOKUP in Excel – free explanation
- IF Function in Excel – Free Explanation with example
- Excel SUMIF Function – Download practice Sheet
- Excel Match Function- Download practice Sheet
- Excel Index Function – Download Practice Sheet
- COUNTIF Excel Function – Download Practice Sheet