how do you subtract two numbers in differant cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know it is an easy question but I just cannot do it. I got the sum thing
going but I need to subtract too. Can you put a subtraction icon on the tool
bar like the sum icon?
Thanks,
Creek
 
Say if A3 is the cell you want to show the result of A1-A2.
Type =A1-A2 in cell A3
 
You could use the Sum icon if you enter your data appropriately.

A1 = 25
A2 = -20
Select A3, and click on the sigma icon, and hit <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I know it is an easy question but I just cannot do it. I got the sum thing
going but I need to subtract too. Can you put a subtraction icon on the tool
bar like the sum icon?
Thanks,
Creek
 
If you really want the subtraction icon (not needed) right click on the
toolbar>customize>insert>subtraction sign.
 
It all makes sense now,
Thanks,
Creek

Lee and Rebecca said:
Say if A3 is the cell you want to show the result of A1-A2.
Type =A1-A2 in cell A3
Click to expand...
 
I tried that thanks but i was hoping for a easy method to subtrack but i got
it now.
It is not a one click action.
Creek
 
You must log in or register to reply here.

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

Column sum incorrect upon subtracting 6
Subtracting two cells-one has existing formula???? 7
Subtracting Rounded Numbers 6
How can I subtract cells in two different worksheets? 2
I need a formula for subtracting from a negative number 3
Subtracting Holidays from Calendar Days 4
how do you subtract from the bank balance 1
how do I set up a simple subtraction between two cells 1

Back
Top