Page 8 of 11
NORMSINV
Returns the value of the inverse standard normal distribution function for a specified value.
NORMSINV(x)
NOT
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
NOT(logical_expression)
NOW
Returns the current date and time as a date value.
NOW()
NPER
Calculates the number of payment periods for an investment based on constant-amount periodic paym...
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
NPV
Calculates the net present value of an investment based on a series of periodic cash flows and a ...
NPV(discount, cashflow1, [cashflow2, ...])
OCT2BIN
Converts a signed octal number to signed binary format.
OCT2BIN(signed_octal_number, [significant_digits])
OCT2DEC
Converts a signed octal number to decimal format.
OCT2DEC(signed_octal_number)
OCT2HEX
Converts a signed octal number to signed hexadecimal format.
OCT2HEX(signed_octal_number, [significant_digits])
ODD
Rounds a number up to the nearest odd integer.
ODD(value)
OFFSET
Returns a range reference shifted a specified number of rows and columns from a starting cell ref...
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
OR
Returns true if any of the provided arguments are logically true, and false if all of the provide...
OR(logical_expression1, [logical_expression2, ...])
PDURATION
Returns the number of periods for an investment to reach a specific value at a given rate..
PDURATION(rate, present_value, future_value)
PEARSON
Calculates r, the Pearson product-moment correlation coefficient of a dataset.
PEARSON(data_y, data_x)
PERCENTILE
Returns the value at a given percentile of a dataset.
PERCENTILE(data, percentile)
PERCENTILE.EXC
Returns the value at a given percentile of a dataset, exclusive of 0 and 1..
PERCENTILE.EXC(data, percentile)
PERCENTILE.INC
See PERCENTILE
PERCENTILE.INC(data, percentile)
PERCENTRANK
Returns the percentage rank (percentile) of a specified value in a dataset.
PERCENTRANK(data, value, [significant_digits])
PERCENTRANK.EXC
Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
PERCENTRANK.EXC(data, value, [significant_digits])
PERCENTRANK.INC
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
PERCENTRANK.INC(data, value, [significant_digits])
PERMUT
Returns the number of ways to choose some number of objects from a pool of a given size of object...
PERMUT(n, k)
PERMUTATIONA
Returns the number of permutations for selecting a group of objects (with replacement) from a tot...
PERMUTATIONA(number, number_chosen)
PHI
The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1..
PHI(x)
PI
Returns the value of Pi to 14 decimal places.
PI()
PMT
Calculates the periodic payment for an annuity investment based on constant-amount periodic payme...
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
POISSON
See POISSON.DIST
POISSON(x, mean, cumulative)
POISSON.DIST
Returns the value of the Poisson distribution function (or Poisson cumulative distribution functi...
POISSON.DIST(x, mean, [cumulative])
POW
Returns a number raised to a power.
POW(base, exponent)
POWER
Returns a number raised to a power.
POWER(base, exponent)
PPMT
Calculates the payment on the principal of an investment based on constant-amount periodic paymen...
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
PRICE
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on...
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
PRICEDISC
Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
PRICEMAT
Calculates the price of a security paying interest at maturity, based on expected yield.
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
PROB
Given a set of values and corresponding probabilities, calculates the probability that a value ch...
PROB(data, probabilities, low_limit, [high_limit])
PRODUCT
Returns the result of multiplying a series of numbers together.
PRODUCT(factor1, [factor2, ...])
PROPER
Capitalizes each word in a specified string.
PROPER(text_to_capitalize)
PV
Calculates the present value of an annuity investment based on constant-amount periodic payments ...
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
QUARTILE
Returns a value nearest to a specified quartile of a dataset.
QUARTILE(data, quartile_number)
QUARTILE.EXC
Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4..
QUARTILE.EXC(data, quartile_number)
QUARTILE.INC
See QUARTILE
QUARTILE.INC(data, quartile_number)
QUERY
Runs a Google Visualization API Query Language query across data.
QUERY(data, query, [headers])
QUOTIENT
Returns one number divided by another.
QUOTIENT(dividend, divisor)
RADIANS
Converts an angle value in degrees to radians.
RADIANS(angle)
RAND
Returns a random number between 0 inclusive and 1 exclusive.
RAND()
RANDARRAY
Generates an array of random numbers between 0 and 1..
RANDARRAY(rows, columns)
RANDBETWEEN
Returns a uniformly random integer between two values, inclusive.
RANDBETWEEN(low, high)
RANK
Returns the rank of a specified value in a dataset.
RANK(value, data, [is_ascending])
RANK.AVG
Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...
RANK.AVG(value, data, [is_ascending])
RANK.EQ
Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...
RANK.EQ(value, data, [is_ascending])