Archive

Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate’s capacity.

Performs division and returns alternate result or BLANK() on division by 0.

Converts radians into degrees.

Evaluates the argument and returns the result as currency data type.

Returns the hyperbolic cosine of a number.

Returns the cosine of the given angle.

Returns the number of combinations (with repetitions) for a given number of items.

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.

Rounds a number up, to the nearest integer or to the nearest multiple of significance.