Returns the formula at the given reference as a text string.
Söz dizimi
FORMULATEXT(reference)Bağımsız değişkenler
referencezorunlu
A reference to a cell or range of cells.
The FORMULATEXT function extracts the formula from a specified cell and displays it as plain text. This is particularly useful for auditing spreadsheets or documenting complex calculations without needing to click into the formula bar.
=FORMULATEXT(A1)→=SUM(B1:B10)If cell A1 contains the formula =SUM(B1:B10), this function returns that formula as text.
Select the target cell
Click on the cell where you want the formula text to appear.
Enter the function
Type =FORMULATEXT( followed by the cell reference you want to inspect, then press Enter.
The function will return a #N/A error.