60
CHAPTER 3:
HancomMobileSheet
COMBI(value, chosen number)
Calculates the number of combinations for a given
number of items.
CONVERT(from_unit, to_unit, value)
Converts a value from metric to English systems and
vice versa.
CORREL(range1, range2)
Calculates the correlation coefficient of two cell
ranges, which have the data from sample.
CORRELMO(range1, range2)
Calculates the correlation coefficient of two cell
ranges, which have the data from population.
COS(radian value)
Returns the cosine of radian value.
COSH(radian value)
Returns the hyperbolic cosine value of radian value.
COUNT(value1, value2,...)
Counts the number of cells that contain numbers.
COUNTA(object value, value1, value2,...)
Calculates the number of object value within values.
COUNTEXT(value1, value2,...)
Counts the number of cells that contain character
and the result of formula is number.
COUNTIF(data range, condition)
Calculates the amount of data from data range that
meets the given condition.
COV(range1, range2)
Calculates covariance, the average of the products of
deviations of corresponding components of two
ranges, which is from sample.
COVMO(range1, range2)
Calculates covariance, the average of the products of
deviations of corresponding components of two
ranges, which is from population.
CRITBINOMIAL(trial, probability, criterion
probability)
Calculates the largest value for which the cumulative
binomial distribution is less than or equal to a
criterion probability.
DATE(number)
Calculates the date from a number.
DVAR(data, field, condition)
Calculates the average of the field column which fits
the condition.
DB(cost, salvage, life, period, month)
Calculates the depreciation of an asset for a
specified period using the fixed declining balance
method.
DCOUNT(data, field, condition)
Calculates the amount of data that match the
conditions.
DDB(cost, salvage, life, period, rate)
Calculates the depreciation of an asset for a
specified period using the double declining balance
method or some other method by rate.
DECTOHEX(decimal value, character
number)
Converts decimal value to hexadecimal.
DEGREE(radian value)
Converts radians into degrees.
DEVSUMSQR(value1, value2,...)
Calculates the sum of squares of deviations of data
points from their sample mean.
DMAX(data, field, condition)
Calculates the largest value in the field that matches
the conditions.
To Next Page
Loading...
Need help?
General
