formula doesn't display result

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

Formulas I enter are being displayed as formula only,
cannot get it to display result. I've tried formatting as
number, used f2 still no result. Also have no merged cells
within the formula groups. Help!
 
The cells were probably formatted as text before you entered the formulas.
Re-formatting doesn't help.
First format the cell as General, then enter the formula.
 
Back
Top