View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Formula displayd as text ???

When I put this in a cell:
=IF(C8="","",B7+1)
it is displayed exactly as typed rather than acting as a formula (which it
is).
This has happened to me in the past on other spreadsheets, and I managed to
fix the issue by copying (dragging) a similar formula from an adjacent cell.
What is going on??
--
Traa Dy Liooar

Jock