View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default how do i do adding and subtracting on excel

This is using a simple formula entered in cell A6
=sum(a3:a5)
so now cell A6 will display the addition of A3 A4 and A5

similarly you could have a cell with the formula =A9-A8


Or if you just want to do a quick addition in a cell as if you are using a
calculator
enter in any cell =5+5+100-50 and push F9 button
the result 60 will display in that cell as a value.

Greetings from New Zealand

"Paul B" wrote in message
...
Angela, may need more information on what you want to do, but

=A1+B1
=5+5
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"angela" wrote in message
...
help