IF Function in MS Excel

IF Function

The IF function is used to make decisions. It returns one value if a specified condition evaluates to TRUE and another value if it evaluates to FALSE. For example, you can display a massage “Pass” if marks are more than 40 or “Fail” otherwise. The syntax for the IF function is:

If(condition, value_if_ture, value_if_false)

Condition is the value to be tested.

IF Function in MS Excel

Value_if_true is the value that is returned if condition evaluates to TRUE.

Value_if _false is the value that is returned if condition evaluates top FALSE.

Insert marks of the student in A1.

Type IF(A1>40,”Pass”,”Fail”) in B1

Press ENTER

If the value of A1 is more than 40, “Pass” will be displayed in B1. Otherwise

“Fail” will be displayed

If my posts are useful for you، or if there is any reduction in them so kindly comment me.