how do I do subtractions in excel

B

Bob Phillips

=A1-B1

=B1-12

=17-11

??

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bernard Liengme

Your question makes me wonder if you have been lead astray by the SUM
function.
While =SUM(A1,B1) will indeed add the two values, it is better to use =A1+B1
SUM is best used fro ranges as in =SUM(A1:A100) which is easier to use than
=A1+A2+A3......+A99+A100
best wishes
 

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

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
subtract column right from column left in excel? 2
How do I subtract one column from another? 4
Trying to create a formula for adding and subtracting columns. 4
how do i add and subtract 4
Excel Having trouble subtracting one cell from another and storing the result. Pls help. 3
Excel Subtract text after the third space and before the fourth (from between spaces) 3
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2

Top