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.
Полезна?
Ограничение на знаците: 250
Ограничението за знаци е 250.
Благодарим ви за обратната връзка.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.