View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathy Niebur Kathy Niebur is offline
external usenet poster
 
Posts: 1
Default FORMULA VS VALUE

Is there a function in Excel or functions I could group together to determine
if the contents of a given cell are a formula vs. a value ? For example, I
would want to evaluate the contents of a cell displaying 3,450 to determine
if that was a number typed into the cell (a numeric value) vs the result of a
formula in the cell (=E5+E6) for example. I know how to manually display the
formulas in a worksheet. I want to write a formula to CHECK for the presence
or absence of a formula in a given cell. Being able to check for the EXACT
formula would be even better. For example, =IF(B3<"=E5+E6","NOT
CORRECT',"CORRECT")

Any help?