test if cell contains formula

[wjg]

I want to test if a cell contains a formula / calculation or a value.
Example: Cell A2 contains the formula =B4+D7 and displays the result vs.
Cell A2 contains a number that has been directly input.
Any clues on how to accomplish?

 

[Frank Kabel]

Hi
are you the same as 'wammer'?. Just look at the thread below this one

 

[wjg]

Looks like the order I am seeing is different but I did see a thread for the
same issue and the suggestion to use rng.FORMULA to create custom. I'll try
that unless someone has something else better.
Thanks
Warren

 

[Harlan Grove]

Looks like the order I am seeing is different but I did see a thread
for the same issue and the suggestion to use rng.FORMULA to create
custom. I'll try that unless someone has something else better.

....

There's nothing better. XLM or VBA are your only alternatives, and VBA is
more flexible.