Isformula Excel 2010

Heyjoe

New member
Joined
Jan 3, 2019
Messages
59
Reaction score
0
Points
0
Location
USA
Excel Version(s)
2019
Excel users,

I am surprised that Excel 2010 does not have an isformula function. Is there an alternative way to test for a formula without using code or user defined functions?
 
How about
=NOT(ISNA(FORMULATEXT(B4)))
 
Thanks Fluff,

Excel 2010 does not have the FormulaText function either. That is OK. I think I can get by without this function.
 
Apologies for that, I thought that it came in 2010, obviously not
 
Back
Top