Returns the formula at the given reference as a text string.
この関数は Google スプレッドシートでも 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.