formulas and Functions
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
To enter a formula, execute the following steps.
1. Select a cell.
2. To let Excel know that you want to enter a formula, type an equal sign (=).
3. For example,
The syntax for the IF functions in Microsoft Excel is:
IF( condition, [value_if_true], [value_if_false] )
condition
The value that you want to test.
value_if_true
Optional. It is the value that is returned if condition evaluates
to TRUE.
value_if_false
Optional. It is the value that is return if condition evaluates to
FALSE. learn More http://www.techonthenet.com/excel/formulas/if.php



No comments:
Post a Comment