if formula in cell

[Hamster & Pene]

Hi Team

What I want to do is, if
Cell.... A1 contains formula then do something if it contain a number do
something else.


I thought it would be =if(ISREF(A1),100,200) or the ISNUM function, the IS
function don't detect


thanks Phill

 

[Guest]

if your formula results in a number =isnumber will say true......if it is
text ,false,if a date true....

 

[Guest]

perhaps the = cell() function can detect the type of value you need?