LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 63
Default Weight differece need everyting to be positive

I am having a hard time trying to figure out a solution to this problem. I
am setting up a spread sheet with shipping weights. Some packages go out
over weight other go out under weight and I want to setup a spread sheet that
shows the total weights we are off. I have a colom that has our weight, the
next colom is the shipper's weight, and the 3 is how much the weight is off.
The probem that I have is that with the weights in the 3rd row when I add
them up I have postive and negative numbers so I am not getting a true total
off the how much we were off by in our systems. I am wondering how can I
make this so that negative numbers will add up as a postive number or that a
negative number will show and add up as a positive number.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gridline weight Nick Turner Charts and Charting in Excel 2 November 7th 06 10:22 PM
Converting weight Mark Allison New Users to Excel 2 May 24th 06 12:51 PM
Weight loss line chart to monitor weight loss progress S Fox Charts and Charting in Excel 6 November 8th 05 05:10 PM
weight formula [email protected] Excel Worksheet Functions 4 February 24th 05 06:38 AM
Imperial weight oakleyroma Charts and Charting in Excel 0 January 11th 05 09:15 PM


All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"