Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |