Returns the formula at the given reference as a text string.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: =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.