Negative values in a formula

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

Guest

How do you enter a formula to add the value of cells in a column, but minus
negative values in the column?

Susan
 
Do you mean that when you add the numbers you want to treat the negative
numbers as zero, or that you want to treat them as positive (and take the
absolute value)?
 

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

subtract a positive from a negative 7
Red cell for negative numbers in Excel 1
Subtracting positive amts from negative and positive from positive 3
Need Help with "SUM" AND "ABS" in same formula 12
How to count the maximum number of consecutives? 9
Negative number format 5
... Count, <<< Positive Values minus Negative Values >>> ... 4
Automatic Negative Column 2

Back
Top