Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / April 2007

Tip: Looking for answers? Try searching our database.

Weight differece need everyting to be positive

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neal - 20 Apr 2007 20:38 GMT
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
John - 20 Apr 2007 22:18 GMT
if the data was in cells a1:a3 then try =SUMPRODUCT(ABS(A1:A3))
Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> 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
[quoted text clipped - 8 lines]
>
> Thanks
Elkar - 20 Apr 2007 22:28 GMT
Use the ABS function to return an Absolute Value.

=ABS(A1-B1)

HTH,
Elkar

> 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
[quoted text clipped - 8 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.