Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 85
Default how do i do adding and subtracting on excel

help
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 709
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
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





  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding and subtracting using vb code ASU Excel Discussion (Misc queries) 2 October 7th 06 09:48 AM
adding and subtracting columns sierra_louise Excel Worksheet Functions 3 August 24th 06 11:45 AM
Rounding Error when adding or subtracting two cells mtheo Excel Worksheet Functions 2 February 28th 06 06:51 PM
How to display 5.5 hours instead of 5.30 when adding \ subtracting excel novice Excel Discussion (Misc queries) 4 November 26th 05 04:22 AM
Adding Subtracting Time Formula-Horse Racing SMDIYDLI Excel Discussion (Misc queries) 1 December 13th 04 09:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"