how do I do subtractions in excel

ladyace · External Since: Aug 07, 2007 Posts: 1

how do I do subtractions in excel.

Bob Phillips · External Since: Mar 01, 2007 Posts: 963

=A1-B1

=B1-12

=17-11

??

--
HTH

Bob

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

"ladyace" <ladyace.RemoveThis@discussions.microsoft.com> wrote in message
news:AEF9F657-3107-4EC8-9570-ECD70FBE3BED@microsoft.com...
> how do I do subtractions in excel.

Bernard Liengme · External Since: Jan 27, 2004 Posts: 2549

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ladyace" <ladyace RemoveThis @discussions.microsoft.com> wrote in message
news:AEF9F657-3107-4EC8-9570-ECD70FBE3BED@microsoft.com...
> how do I do subtractions in excel.