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

G

Guest

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

Roger Govier

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
 
P

Pete_UK

If you have pounds in A1, then put this formula in B1:

=A1/2000

Hope this helps.

Pete
 

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

Excel Converting Total tons into ponds per Yard 0
Convert input cell into metric tons 3
Is VLOOKUP what I need for this? 1
calculate shipping costs in excel 2007 2
WEIGHT CONVERSION??? 3
Calculate rolling average using last 30 values greater than 0. 3
IF formula for currency or Macro help. 0
If Statement with VLookup 3

Top