View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrcpuhead mrcpuhead is offline
external usenet poster
 
Posts: 1
Default IF function results not displayed in cell

I've added a correctly formatted IF statement to a Text cell in a worksheet
(Excel 2003), but instead of showing the result, it shows the formula in the
cell.
I've tried the Ctrl ` key combo - that doesn't help.
Even if I then replace the cell's contents with a simple reference to
another cell (for example =G23), the cell shows the reference instead of the
value of the other cell.