Microsoft Office Tutorials and References
In Depth Information
Understanding Functions
11
CHAPTER
EXCEL
Working with Formulas and Functions
Common Functions
The following table lists some of the more popular Excel functions that you might use with your own
spreadsheet work.
Function
Category
Description
Syntax
SUM
Math & Trig
Adds values
=SUM(number1,number2,...)
ROUND
Math & Trig
Rounds a number to a
specified number of digits
=ROUND(number,number_digits)
ROUNDDOWN
Math & Trig
Rounds a number down
=ROUNDDOWN(number,number_digits)
INT
Math & Trig
Rounds down to the nearest
integer
=INT(number)
COUNT
Statistical
Counts the number of cells in
a range that contain data
=COUNT(value1,value2,...)
AVERAGE
Statistical
Averages a series of arguments
=AVERAGE(number1,number2,...)
MIN
Statistical
Returns the smallest value in
a series
=MIN(number1,number2,...)
MAX
Statistical
Returns the largest value in
a series
=MAX(number1,number2,...)
MEDIAN
Statistical
Returns the middle value in
a series
=MEDIAN(number1,number2,...)
PMT
Financial
Finds the periodic payment
for a fixed loan
=PMT(interest_rate,number_of_
periods,present_value,future_value,type)
RATE
Financial
Returns an interest rate
=RATE(number_of_periods,payment,
present_value,future_value,type,guess)
TODAY
Date & Time
Returns the current date
=TODAY()
IF
Logical
Returns one of two results
that you specify based on
whether the value is true
or false
=IF(logical_text,value_if_true,value_if_
false)
AND
Logical
Returns true if all of the
arguments are true, and false
if any argument is false
=AND(logical1,logical2,...)
OR
Logical
Returns true if any argument
is true, and false if all
arguments are false
=OR(logical1,logical2,...)
201
Search JabSto ::




Custom Search