Modifying this control will update this page automatically

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