Checks whether a reference contains a formula and returns TRUE or FALSE.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
ISFORMULA(reference)The ISFORMULA function determines if a cell contains a formula. It returns TRUE if the cell contains a formula, and FALSE if it contains a static value or is empty.
=ISFORMULA(A1)결과: TRUE
Returns TRUE if cell A1 contains a formula like =SUM(B1:B5).
=ISFORMULA(100)결과: FALSE
Returns FALSE because 100 is a static number, not a formula.
Yes, you can reference cells in other sheets using the syntax =ISFORMULA(Sheet2!A1).