How do you subtract negative numbers?

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

Guest

I am doing budget and I have a column of numbers to add but I have to include
the numbers to subtract?
 
Deb

Just enter them in cells as negative numbers.


Enter the following to test:

A1 -1
A2 2
A3 -1
A4 = Sum(A1:A3)

Answer in A4 will be 0

HTH

Steve
 
Or, if you want to enter them as positive numbers, use a formula like:

=sum(a1:a5)-sum(a6:a20)
 
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

How to subtract a number from a Mergefield? 0
Negative Numbers in a Pivot Table 1
Negative numbers 3
Auto negative entry 1
subtract entries from allocated total until it reaches zero 1
Subtracting an absolute value 2
Workday Formula to include date 0
adding positive and negative numbers 3

Back
Top