Microsoft Office Tutorials and References
In Depth Information
Understanding Functions
EXCEL
chapter 11
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
Function
Category
Description
Syntax
SUM
Math & Trig
=SUM(number1,number2,...)
INT
Math & Trig
Rounds down to the nearest integer
=INT(number)
ROUND
Math & Trig
Rounds a number specified to a specified
number of digits
=ROUND(number,number_digits)
ROUNDDOWN
Math & Trig
Rounds a number down
=ROUNDDOWN(number,number_digits)
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,
false if any is false
=AND(logical1,logical2,...)
OR
Logical
Returns true if any argument is true, false if
all arguments are false
=OR(logical1,logical2,...)
195

Search JabSto ::

Custom Search