PrecisionCalc
inspector
text
Do Anything with Text in Formulas
itFORMULA
Returns the formula of the referenced cell, as text.
Syntax
itFORMULA(target_cell, omit_equals_sign)
| target_cell | Required. The cell for which to return the formula. |
| omit_equals_sign | Optional. Determines whether to include equals sign ("=") in the returned formula. False by default. |
Examples
| Formula | Description | Result |
| =itFORMULA(A1) | Return the formula in cell A1. | =B2 (if cell A1 contains the formula "=B2".) |
| =itFORMULA(A1, TRUE) | Return the formula in cell A1, without the equals sign. | B2 (if cell A1 contains the formula "=B2".) |