Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula to convert pounds to tons( 2000) lbs per ton
Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.)
in excel spreadsheets |
#2
|
|||
|
|||
Answer: need a formula to convert pounds to tons( 2000) lbs per ton
Converting Pounds to Net Tons in Excel
To convert pounds to net tons (2000 lbs), use the following formula in Excel: Formula:
Excel will divide the number of pounds by 2000 and display the result in the cell. In the example above, the result would be 2.5 net tons. You can also use cell references in your formula instead of typing in the numbers directly. For example, if the number of pounds you want to convert is in cell A1, you can use the following formula: Formula:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula to convert pounds to tons( 2000) lbs per ton
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 -- Regards Roger Govier "Liverpool Loo" <Liverpool wrote in message ... Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.) in excel spreadsheets |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula to convert pounds to tons( 2000) lbs per ton
If you have pounds in A1, then put this formula in B1:
=A1/2000 Hope this helps. Pete On Feb 9, 3:40 pm, Liverpool Loo <Liverpool wrote: Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.) in excel spreadsheets |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula to convert pounds to tons( 2000) lbs per ton
Why not =A1/2000 ?
-- David Biddulph "Liverpool Loo" <Liverpool wrote in message ... Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.) in excel spreadsheets |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula to convert pounds to tons( 2000) lbs per ton
New user? "David Biddulph" wrote: Why not =A1/2000 ? -- David Biddulph "Liverpool Loo" <Liverpool wrote in message ... Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.) in excel spreadsheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
formula to convert raw data from several sources into relative tot | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
VBA | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions |