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)
e.g.
=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