Joe,

Since your file is inside the excel environment, excel built-in tools are
provided for more convenience and distinction of data entered in its
environment.

My previous suggestion is a copy-paste from excel platform.

--
regards,


"Joe" wrote:

I have a column with formulas and another column with just values and I want
to do an IF statement by checking if the cell contents are a formula or not.
I know many times I have problems with a cell if it has a formula which would
not be there if the it was just plain numbers so there should be a way to
tell them apart with a caculation or function.

"Joe" wrote:

how do you do an if statement to check if a cell contains a value like a
number or a formula?