Formula problem in Excel 2007

M

Mike Magna

I am a very experienced Excel user but new to Office 2007. Tried to enter a
simple reference formula, for instance in cell c4 I typed =a2+1. Instead of
working properly, the cell showed the formula as text. For some cells it
worked, once only, but as soon as I changed the reference, it failed again.
This is extremely frustrating and any help would be appreciated.
 
T

trip_to_tokyo

Mike I have tried to replicate your problem in EXCEL 2007 and this is what I
get:-

- cell C4 is formatted as General

- now in cell C 4 I type:-

=A2+1

- cell C 4 now displays the number 1

- cell A 2 is blank

Now if I type 20 in cell A 2 I get:-

21

- in cell C 4.

As far as I can see I cannot replicate your problem.

Please hit Yes if my comments have helped.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top