FORMULATEXT

The FORMULATEXT function returns a formula as a text string. FORMULATEXT returns what is displayed in the formula bar when you select a cell.

FORMULATEXT(reference)

reference: A cell or range of cells.

Examples

Given the following table, which shows the result of basic numeric formulas using the cells in column A, including SUM, AVERAGE, MIN, MAX, MEDIAN, and COUNT:

A

B

1

Value

Results

2

56

300

3

74

50

4

24

17

5

87

87

6

42

49

7

17

6

=FORMULATEXT(B2) returns "=SUM(A2:A7)," which is the formula used in cell B2.

=FORMULATEXT(B6) returns "=MEDIAN(A2:A7)," which is the formula used in cell B6.

See alsoINDIRECT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.