Easy Explanation Notes with Examples

Excel FORMULATEXT Function

FORMULATEXT function returns a text string from given reference containing a formula.

Syntax

FORMULATEXT(reference)

The function has the following argument in the syntax:

(reference) – Required. The reference to a cell/ range of cells, containing a formula.

Example

Data
Formula
Result
ErrorOccurs If

#N/A
The FORMULATEXT function is used on a reference that does not contain a formula.

#N/A
The reference argument is from another workbook that is not open.

#N/A
The formula in the cell is more than 8192 characters long.

#N/A
The worksheet having reference argument is protected.
VALUE! If invalid cell reference is provided.

For more detail, visit Microsoft Excel website.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved