Sunday, Nov. 19, 2017

45 Essential Numbers Functions You Should Know About

Written By:

|

January 10, 2012

|

Posted In:

45 Essential Numbers Functions You Should Know About

Numbers is Apple’s native spreadsheet app comparable to Microsoft Excel. Specifically designed for the iPad, Numbers is a great app for those looking to crunch numbers on the iPad. With over 250 functions built into Numbers, here are 45 of the most used functions you should know about.

Date & Time

DATEIF
Returns the number of days, months, or years between two dates.

NETWORKDAYS
Returns the number of working days between two dates. Working days exclude weekends and any other specified dates.

TIMEVALUE
Returns the time as a decimal fraction of a 24-hour day from a given date/time value or from a text string.

DURATION
Combines separate values for weeks, days, hours, minutes, seconds, and milliseconds and returns a duration value.

Engineering

CONVERT
Converts a number from one measurement system to its corresponding value in another measurement system.

BASETONUM
Converts a number of the specified base into a number in base 10.

Financial

ACCRINT
Calculates the accrued interest added to the purchase price of a security and paid to the seller when the security pays periodic interest.

ACCRINTM
Calculates the total accrued interest added to the purchase price of a security and paid to the seller when the security pays interest only at maturity.

CUMIPMT
Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.

CUMPRINC
Returns the total principal included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.

EFFECT
Returns the effective annual interest rate from the nominal annual interest rate based on the number of compounding periods per year.

DISC
Returns the annual discount rate of a security that pays no interest and is sold at a discount to its redemption value.

FV
Returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.

INTRATE
Returns the effective annual interest rate for a security that pays interest only at maturity

IPMT
Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate.

IRR
Returns the internal rate of return for an investment that is based on a series of potentially irregular cash flows that occur at regular time intervals.

ISPMT
Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate. This function is provided for compatibility with tables imported from other spreadsheet applications.

NOMINAL
Returns the nominal annual interest rate from the effective annual interest rate based on the number of compounding periods per year.

NPV
Returns the net present value of an investment based on a series of potentially irregular cash flows that occur at regular time intervals.

PMT
Returns the fixed periodic payment for a loan or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.

PV
Returns the present value of an investment or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.

RATE
Returns the interest rate of an investment, loan, or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.

YIELD
Returns the effective annual interest rate for a security that pays regular periodic interest.

YIELDMAT
Returns the effective annual interest rate for a security that pays interest only at maturity.

Numerical

ABS
Returns the absolute value of a number or duration.

PRODUCT
Returns the product of one or more numbers.

SUM
Returns the sum of a collection of numbers.

SUMPRODUCT
Returns the sum of the products of corresponding numbers in one or more ranges.

SUMIF
Returns the sum of a collection of numbers, including only numbers that satisfy a specified condition.

Reference

ADDRESS
Constructs a cell address string from separate row, column, and table identifiers.

CHOOSE
Returns a value from a collection of values based on a specified index value.

HLOOKUP
Returns a value from a range of rows by using the top row of values to pick a column and a row number to pick a row within that column.

LOOKUP
Finds a match for a given search value in one range, then returns the value in the cell with the same relative position in a second range.

TRANSPOSE
Returns a vertical range of cells as a horizontal range of cells, or vice versa.

Statistics

AVEDEV
Returns the average of the difference of a collection of numbers from their average (arithmetic mean).

AVERAGE
Returns the average (arithmetic mean) of a collection of numbers.

BETADIST
Returns the cumulative beta distribution probability value.

CORREL
Returns the correlation between two collections using linear regression analysis.

COUNT
Returns the number of its arguments that contain numbers, numeric expressions, or dates.

STDEV
Returns the standard deviation, a measure of dispersion, of a collection of values based on their sample (unbiased) variance.

NORMDIST
Returns the normal distribution of the specified function form.

PERCENTILE
Returns the value within a collection that corresponds to a particular percentile.

PERCENTRANK
Returns the rank of a value in a collection as a percentage of the collection.

PERMUT
Returns the number of permutations for a given number of objects that can be selected from a total number of objects.

VAR
Returns the sample (unbiased) variance, a measure of dispersion, of a collection of values.

Share This Article

Related News

How to (Manually) Update to iOS 5.1 for iPad, iPhone, and iPod Touch
Different ways to search Calendar events on the iPad
How to Extend your iPad’s battery life with Battery Boost Magic App

About Author

My App World