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

L

Liverpool Loo

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

calculate shipping costs in excel 2007 3
Is VLOOKUP what I need for this? 1
Calculate rolling average using last 30 values greater than 0. 3
Convert input cell into metric tons 3
Calculate Pounds Per Hour 4
WEIGHT CONVERSION??? 3
Finding the corresponding value in a range? 4
how do i use excel to calculate weight (as in stone and lbs)? 6

Top