View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default My formula displays just as it is, instead of calculating

Sorry,

That should have been:

Ctrl + `

` is directly above the Tab key.

Regards,
Paul

"Mark Parent" wrote in message
...
I'm working with a spreadsheet that was passed to me, and I haven't
created
it from scratch. I've added a column and created a simple formula that
simply displays in the cell instead of showing me the calculated result.
I've checked that automatic calculation is ON. The cell simply displays
=IF(D2=8,E2,"") instead of showing me the value of cell E2 or the empty
value. I've also tried various other formula; they all behave similarly.

I can't imagine what would cause the formula to display, almost like it's
being considered as a text string.....