At work I use a network, Windows 7 and Excel 2003.

Have set up a spreadsheet using IF statements. I exceeded 7 statements and have extended the equation using &.

I tried to amend an equation in a cell by clicking in the the formula bar and adding in another step. The change was accepted but the cell doesnt show the answer. It does show the formula.



I checked the format of the cell and it had changed from General to Text. I changed the format back to General but still only see the formula and not the answer. The sheet is set to show product of formula and not Show Formula.

I also use COUNTA in the spreadsheet and amending a formula eg the range, results in the same problem.

What am I doing wrong and how can I fix it?

Grateful for any assistance.