Formula displayd as text ???

  • Thread starter Thread starter Jock
  • Start date Start date
J

Jock

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??
 
Hi Jock

It sounds as though the cell has been pre-formatted as Text.
Try Format>Cells>Number>General
then enter your formula

If it still shows as the formula, as opposed to the result, then you have
the Toggle set to Display Formulas
Press the Control button + ` (the key to the left of number 1 on the top
row of the keyboard)

This toggles the mode between displaying formulas, and displaying the
results of formulas.
 
Thanks Roger, that was it.

--
Traa Dy Liooar

Jock


Roger Govier said:
Hi Jock

It sounds as though the cell has been pre-formatted as Text.
Try Format>Cells>Number>General
then enter your formula

If it still shows as the formula, as opposed to the result, then you have
the Toggle set to Display Formulas
Press the Control button + ` (the key to the left of number 1 on the top
row of the keyboard)

This toggles the mode between displaying formulas, and displaying the
results of formulas.
Click to expand...
 
Back
Top