View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Viviank Viviank is offline
external usenet poster
 
Posts: 6
Default formula help:adding without regard to +/-

How do I tell excel to add a column of numbers without regard to +/- sign. I
want to know the gross total of all adjustments, not the net. Here's the
scenario. A house sells for $200,000, we make adjustments for differences,
say -$1,000 here, +3,000 there, I want excel to tell me that I've made $4000
in adjustments - not +2000. Thanks for your help.

Vivian