62
CHAPTER 3:
HancomMobileSheet
GEODIST(value, probability, cumulative)
Calculates the probability of the trial number of the
first success as random variable(value).
GEOMEAN(value1, value2, ...)
Calculates the geometric mean of value or range.
HATMOMEAN(value1, value2, ...)
Calculates the harmonic mean of value.
HEXTODEC(hexadecimal value)
Changes the hexadecimal value into a decimal
format.
HLOOKUP(lookup value, data range, row
index, appropriate)
Looks for a value in the top row of the data range,
and then returns a value in the same column from a
row specified by the row index.
HOUR(number)
Calculates the hour from the number.
HYPERGEO(number of population, number
of success in population, number of sample,
success number in sample, cumulative)
Calculates the probability of the hypergeometric
distribution.
IF(condition, true value, false value)
Calculates a value if a specified condition evaluates
to true and another value if it evaluates to false.
INDEX(data range, row number, column
number)
Returns a value within a data range according to row
number and column number.
INOMINAL(real rate, number of period)
Calculates nominal rate per year, which can make a
real rate with applying compound interest rate.
INT(value)
Rounds a number down to the nearest integer.
INTERCEPT(independent range, dependent
range)
Calculates intersection of the Y axis from regression.
IPMT(nper, per, rate, pv, fv, point)
Calculates interest payment for a given period(nper)
for an investment in case of constant payments and
a constant interest rate.
IREAL(nominal rate, number of period)
Calculates real rate per year by applying compound
interest rate.
IRR(value range, guess rate)
Calculates the internal rate of return at a regular
intervals.
KURTOSIS(value1, value2,...)
Calculates kurtosis to determine relative pickness of
a distribution compared with normal distribution.
LARGE(data range, value)
Returns the k-th largest value in a data range.
LAS(base period price, base period quantit-
y, compare period, type)
Calculates Laspeyres index.
LEFT(string, value)
Returns the leftmost characters in a text string.
LENGTH(string)
Returns the number of character in a string.
LN(value)
Returns the natural logarithm of a value.
LOG(base, value)
Returns the logarithm of a value to the base.
LOOKUP(lookup value, data range, result
range)
Returns a value of result range based on the result
of lookup value in data range.
LOWER(string)
Changes all uppercase letters into lowercase.
MAED(base period price, base period
quantity, compare period price, compare
period quantity, type)
Calculates Marshall-Edgeworth index.
To Next Page
Loading...
