View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default value vs formula

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?