|
HASFORMULA2 function
The HASFORMULA function returns true if any of the cells in the range contain a formula.
HASFORMULA is NOT multi-threaded, NOT volatile and is NOT an array function.
HASFORMULA2 Syntax
HASFORMULA2(theRange)
theRange
Any valid range references.
The function returns true if any of the cells in the range contains a formula, otherwise false.
HASFORMULA 2Remarks
The function considers the following as formulas:
=2
+2
=a1
=”Text”
=NOW()
=RangeName
The function will return False for the following:
2
45
“Text”
|
