O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Alphabetical List of Excel 2010 Functions

Table C-1. Alphabetical List of Excel 2010 Functions

Function

Description

ABS

Returns the absolute value of a number. Takes the form =ABS(number). If a number is negative, this function simply removes the sign, making it a positive number.

ACCRINT

Returns the interest accrued by a security that pays interest on a periodic basis. Takes the form =ACCRINT(issue, first interest, settlement, rate, par, frequency, basis), where issue is the issue date of the security, first interest is the date of the initial interest payment, settlement is the day you pay for the security, rate is the interest rate of the security at the issue date, par is the par value of the security, frequency is the number of coupon ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required