Microsoft Office Tutorials and References

In Depth Information

**Debugging your formulas**

Category

Function Name

Description

Financial

PDURATION

Calculates the number of periods that an investment will take to reach a value.

Financial

RRI

Calculates the equivalent interest rate for the growth of an investment.

Information

ISFORMULA

Returns TRUE if a cell contains a formula.

Information

SHEET

Returns the sheet number of a sheet.

Information

SHEETS

Returns the number of sheets in a reference.

Logical

IFNA

Returns a value that you specify if an expression results in an #N/A error; otherwise, it

returns the value of the expression.

Logical

XOR

Returns the logical exclusive OR of all arguments (that is, it returns TRUE if exactly one

argument is true).

Lookup and Reference

FORMULATEXT

Returns the formula in the referenced cell as text.

Math and Trigonometry

ACOT

Returns the arccotangent of a number.

Math and Trigonometry

ACOTH

Returns the hyperbolic arccotangent of a number.

Math and Trigonometry

ARABIC

Converts a number written as a Roman numeral into an Arabic number.

Math and Trigonometry

BASE

Converts a number into a text representation of the number in a given base.

Math and Trigonometry

CEILING.MATH

Rounds a number up to the nearest integer or to the nearest significant multiple.

Math and Trigonometry

COT

Returns the hyperbolic cosine of a number.

Math and Trigonometry

COTH

Returns the cotangent of an angle.

Math and Trigonometry

CSC

Returns the cosecant of an angle.

Math and Trigonometry

CSCH

Returns the hyperbolic cosecant of an angle.

Math and Trigonometry

DECIMAL

Converts a text representation of a number in a given base to a decimal number.

Math and Trigonometry

FLOOR.MATH

Rounds a number down to the nearest integer or to the nearest significant multiple.