Wednesday, 15 May 2013

If Function in Microsoft Excel

If Function:

One of the important logical function is if. If function is used to check a particular condition and value of function if the condition is true or false.

Syntax :

=if(Condition, value_if_condition is true, Value_if_condition is false)


=if(F2>100, “Yes”,”No”)

For example, in the above function we are checking cell F2,If the value in F2 is greater than 100 then function will return Yes and if the value in F2 is not greater than 100 (mean false condition) then function will return No in active cell.

No comments:

Post a comment