ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i do adding and subtracting on excel (https://www.excelbanter.com/new-users-excel/129020-how-do-i-do-adding-subtracting-excel.html)

Angela

how do i do adding and subtracting on excel
 
help

Paul B

how do i do adding and subtracting on excel
 
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




Bill Kuunders

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






Gord Dibben

how do i do adding and subtracting on excel
 
In any cell enter..................

=6 + 4 or =6 - 4

If you mean using cell references............

A1 = 6 A2 = 4

In A3 enter =A1 + A2 or =A1 - A2

For more help on basics of Excel see these sites.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Fri, 2 Feb 2007 12:22:01 -0800, angela
wrote:

help




All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com