Excel Spreadsheets formulas don't update

G

GGirl

Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and
change one of the numbers to 1+2, I still get 2 in the sum.
 
L

L. Howard Kittle

If you put 1+1+2 in a cell it will return "1+1+2."

If you put =1+1+2 in a cell it will return 4

<change one of the numbers to 1+2, I still get 2 in the sum.>

Makes no sense to me how you "still get 2 in the sum"????

Regards,
Howard
 

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

Similar Threads

Excel - Wich Function should I use? 1
How to automate update on weekly reports spreadsheet 0
Autonumber field in Excel that behaves the same as Access 0
Finding the proper style field and the numbered paragraph value within the style 0
Creating Different Headers in Word 0
Finding the right style field in VBA 0
Excel does not accept text format! 0
Need Help with Macro Security 1

Top