Formulas and Functions
ಈ ನಿಯಂತ್ರಣವನ್ನು ಮಾರ್ಪಡಿಸುವುದರಿಂದ ಈ ಪುಟವು ಸ್ವಯಂಚಾಲಿತವಾಗಿ ಅಪ್‌ಡೇಟ್ ಆಗುತ್ತದೆ

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.