S
Skinman
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.
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.