Microsoft Excel

Microsoft Excel


Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data

formulas and Functions 
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