Formula required
 

Hi all, using excel 2007

I would like a formula to test a column to find out whether
the cells in the column are either a constant, a formula, or
a name that has been defined.

In A1 Putting the formula and filling down as many as required.
Something like:
=IF( B1 is a constant, "constant",IF( B1 is a name,"name", "formula"))

Is that possible in a formula or will the problem only be solved
with a macro?

Regards Skinman.