Thursday, August 14, 2008

Using IF Function On Microsoft Excel

Function of IF is used for trying the correctness of the condition. This is the syntax to use the Function:

= IF (logical_test;value_if_true;value_if_false)

Explanation :

1. Logical_test it’s has a logical value or cell address that will be try

b. Value_if_true it can be has a value, cell address or another condition if the value that will be try has a right big logical value

c. Value_if_false it can be has a value, cell address or another condition if the value that will be try has a wrong value.

Example :

No comments: