|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
|
|
#1
February 18th, 2005, 09:32 PM
|
|||
|
|||
Where cell A1 contains a numeric value in kg, for the stones part use:
In one cell =INT(CONVERT(A1,"kg","lbm")/14) for the remainder in pounds: in another cell =MOD(CONVERT(A1,"kg","lbm"),14) 
|
|
#2
February 19th, 2005, 09:36 AM
|
|||
|
|||
|
oops...wrong one....thats stones and pounds.
Check this formula for converting Kilograms to Pounds and Ounces; be sure you have been to Tools, Add-Ins and checked Analysis Toolpak. =INT(CONVERT(A2,"kg","lbm"))&" lbs " &INT( MOD(CONVERT(A2,"kg","ozm"),16))& " oz"http://www.barasch.com/excel/xlFormulas.htm
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Soft plastics found in trout stomachs | Shawn | Bass Fishing | 28 | August 26th, 2004 05:15 AM |
| Meeting report: 19th Century North America trout propagation | William Claspy | Fly Fishing | 0 | April 22nd, 2004 02:37 PM |
| Gorillas, Trout Fishing, Upper Delaware River | Vito Dolce LaPesca | Fly Fishing | 0 | March 1st, 2004 02:07 PM |
| Trout fishing with worms | mary | Fly Fishing | 33 | January 24th, 2004 06:52 PM |
| record rainbow trout | lucy white | Fly Fishing | 9 | December 4th, 2003 08:11 AM |
Hybrid Mode
