Excel Reference 583
Mathematical Formulas
Function Name Description
IF2FUNC IF2FUNC(Fname, IFRange1, IFValue1, IFRange2,
IFValue2, RangeAnd, [Arg1, Arg2,.. .]) calculates
the value of the Excel function Fname, for rows
in a data set where the values of IFRange1 are
equal to IFValue1 and the values of IFRange2
are equal to IFValue2. Parameters of the
Fname function can be inserted as Arg1, Arg2,
and so forth. If RangeAnd 5 true, an AND
clause is assumed between the two values. If
RangeAnd 5 false, an OR clause is assumed.
IFFUNC IFFUNC(Fname, IFRange, IFValue, [Arg1, Arg2,.. .])
calculates the value of the Excel function Fname,
for rows in a data set where the values of IFRange
are equal to IFValue. Parameters of the Fname
function can be inserted as Arg1, Arg2, and so
forth.
RANDBERNOULLI RANDBERNOULLI(prob) returns a random
number from the Bernoulli distribution with
probability = prob.
RANDBETA RANDBETA(alpha, beta, [a], [b]) returns a
random number from the Beta distribution
with parameters alpha, beta, and (optionally)
a and b where a and b are the end points of the
distribution.
RANDBINOMIAL RANDBINOMIAL(prob, trials) returns a random
number from the binomial distribution with
probability = prob and number of trials = trial.
RANDCHISQ RANDCHISQ(df ) returns a random number
from the chi-square distribution with degrees of
freedom df.
RANDDISCRETE RANDDISCRETE(range, prob) returns a random
number from a discrete distribution where the
values of the distribution are found in the cell
range range, and the associated probabilities are
found in the cell range prob.
RANDEXP RANDEXP(lambda) returns a random number
from the exponential distribution where
l5lambda.
RANDF RANDF(df1, df2) returns a random number from
the F distribution with numerator degrees of
freedom df1 and denominator degrees of freedom
df2.
