how do i do adding and subtracting on excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

angela - 02 Feb 2007 20:22 GMT

help

Reply to this Message

Paul B - 02 Feb 2007 20:56 GMT

Angela, may need more information on what you want to do, but

=A1+B1
=5+5

Signature

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

> help

Reply to this Message

Bill Kuunders - 02 Feb 2007 21:13 GMT

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

> Angela, may need more information on what you want to do, but
>
> =A1+B1
> =5+5
>> help

Reply to this Message

Gord Dibben - 02 Feb 2007 21:16 GMT

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/training/CR061831141033.aspx

Gord Dibben MS Excel MVP

>help

Reply to this Message