Symbols

[ LiB ]
+

Addition operator



-

Subtraction operator



=

Initiates all Excel formulas



*

Multiplication operator



/

Division operator



>

Greater than operator



<

Less than operator



=AVERAGE.

An Excel function that calculates the average of a list of values. SYNTAX: =AVERAGE( list )



=COUNT.

An Excel function that counts the nonblank cells in a list of ranges. SYNTAX: =COUNT( list )



=IF.

An Excel function that evaluates a condition and returns one of two values, depending on the result of the evaluation. If condition is true, =IF returns x; if condition is false, =IF returns y. SYNTAX: =IF( condition;x;y ).



=MAX.

An Excel function that finds the largest value in a list. SYNTAX: =MAX( list )



=MIN.

An Excel function that finds the smallest value in list. SYNTAX: =MIN( list )



=SUM.

An Excel function that adds a range of cells. See also AutoSum . SYNTAX: =SUM( list )



[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net