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.
Search JabSto ::




Custom Search