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.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.