Returns the formula at the given reference as a text string.
Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.
FORMULATEXT(reference)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)Resultado: =SUM(B1:B10)
If cell A1 contains the formula =SUM(B1:B10), this function returns that formula as text.
The function will return a #N/A error.