need a formula to convert pounds to tons( 2000) lbs per ton

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

Guest

Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.)
in excel spreadsheets
 
Hi

The Net Ton or Short ton is 2000 lbs (pounds) so with weight in A1
=A1/2000

The Long ton is 2240 lbs so
=A1/2240
 
If you have pounds in A1, then put this formula in B1:

=A1/2000

Hope this helps.

Pete
 
Back
Top