CHAPTER 3:
HancomMobileSheet
63
MATCH(lookup value, data range, match
type)
Returns the relative position of an item in an array
that matches a specified value in a specified order.
MAX(value1, value2, ...)
Returns the largest value in a set of value.
MEANDEV(value1, value2,...)
Calculates the value that divides sum of absolute
value of each deviation by the amount of data.
MEDIAN(value1, value2, ...)
Returns the median.
MID(string, start, number of character)
Returns the characters to the starting value and the
number of characters.
MIN(value1, value2, ...)
Returns the smallest number in a set of values.
MINUTE(number)
Calculates the minute from the number.
MIRR(value range, financial rate, reinvestm
ent rate)
Calculates modified internal rate of return.
MOD(value, divisor)
Returns the remainder after the value is divided by
the divisor.
MODE(value1, value2, ...)
Returns the most frequently occurring value.
MOMENT(data range, power)
Calculate the moment.
MONTH(number)
Calculates the month from the number.
MULTINOMIAL(value1, value2, value3,...)
Calculates the multinomial.
NEGABINOMIAL(number of trial, number
of success, probability, cumulative)
Calculates the probability of random variable, which
is number of trials before the number t-th success.
NORMAL(value, mean, standarddeviation,
cumulative)
Calculates the probability of normal distribution.
NORMALINV(probability, average, standar
d deviation)
Calculates the inverse of normal distribution.
NORMALSTD(z, cumulative)
Calculates the probability of standard normal
distribution.
NORMALSTDINV(probability)
Calculates the inverse of standard normal distribution.
NOT(logical)
Reverses the logic of its argument.
NOW( )
Shows the current date and time.
NPER(pmt, rate, pv, fv, point)
Calculates the number of periods of an investment.
NPV(investment, rate)
Calculates the net present value of an investment,
witch substract present value of cash investment
from present value of cash income.
NPVX(investment, rate, date)
Calculates irregular net present value.
OR(logical1, logical2, ...)
Returns False(0) only if all arguments are false.
PAAS(base period price, base period
quantity, compare period, type)
Calculates the Paasche index.
PERMUT(value, choose)
Calculates the number of permutations for a given
number of objects that can be selected from value.
PI()
Returns the value of pi(π=3.14159265358979324).
PMT(nper, rate, pv, fv, point)
Calculates the payment for a loan with a constant
payment.
To Next Page
Loading...
Need help?
General
