Microsoft Office Tutorials and References
In Depth Information
Debugging your formulas
Category
Function Name
Description
Math and Trigonometry
ISO.CEILING
Returns a number that is rounded up to the nearest integer or to the nearest
significant multiple.
Math and Trigonometry
MUNIT
Returns the unit matrix of the specified dimension.
Math and Trigonometry
SEC
Returns the secant of an angle.
Math and Trigonometry
SECH
Returns the hyperbolic secant of an angle.
Statistical
BINOM.DIST.RANGE
Calculates the probability of a result using the binomial distribution.
Statistical
COMBINA
Returns the number of combinations for a given number of items, allowing
replacement.
Statistical
GAMMA
Returns the Gamma function value.
Statistical
GAUSS
Returns 0.5 less than the standard normal cumulative distribution.
Statistical
PERMUTATIONA
Returns the number of permutations for a given number of items, allowing
replacement.
Statistical
PHI
Returns the value of the density function for a standard normal distribution.
Statistical
SKEW.P
Returns the skewness of a distribution based on the population instead of a sample
from the population.
Tex t
NUMBERVALUE
Converts text to a number.
Tex t
UNICHAR
Returns the Unicode character referenced by a number.
Tex t
UNICODE
Returns the Unicode number of the first character of a text string.
Web
ENCODEURL
Returns a URL-encoded string.
Web
FILTERXML
Returns specific data from XML content using a user-supplied xpath value.
Web
WEBSERVICE
Returns data from a web service.
Search JabSto ::




Custom Search