If formula then retun on systen

[howard]

I have a mixture of formulas and text in Col H


I would like to set up a formula in Col I, that if there is formula in Col h, then return "on system' , otherwise "not on system"


It would be appreciated if someone could assist me

 

[Michael M]

This works for 2013 onwards
but do you want to Identify the existence of a formula OR a result of the formula

=IF(ISFORMULA(H1),"On System", "Not On System")

 

[howard]

Hi Michael


Thanks for the help. Your formula resolves the issue


I just need to check if there is a formula and return "on system" , otherwise 'not on system"


Regards