 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Kilos to Stones & Pounds
I used the formula below, given elsewhere on this site to convert kilos into Stones & Pounds. =INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1) *14&"lb" When I converted 98 kilos I got the following result 15st 6. 05304563975091lb. Could someone advise how I can amend the formula to round up or down the decimals so that the result would show 15st 6lb. =INT(F6*2.2/14)&"st "&ROUND(MOD(F6*2.2,14),0)&"lb" MH >I used the formula below, given elsewhere on this site to convert kilos >into [quoted text clipped - 5 lines] > round > up or down the decimals so that the result would show 15st 6lb. Thanks for your help >=INT(F6*2.2/14)&"st "&ROUND(MOD(F6*2.2,14),0)&"lb" > [quoted text clipped - 5 lines] >> round >> up or down the decimals so that the result would show 15st 6lb. Try this: =INT(CONVERT(F6,"kg","lbm")/14)&"st "&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb"  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== I used the formula below, given elsewhere on this site to convert kilos into Stones & Pounds. =INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1) *14&"lb" When I converted 98 kilos I got the following result 15st 6. 05304563975091lb. Could someone advise how I can amend the formula to round up or down the decimals so that the result would show 15st 6lb. Thank you for your help >Try this: > [quoted text clipped - 8 lines] >05304563975091lb. Could someone advise how I can amend the formula to round >up or down the decimals so that the result would show 15st 6lb. =INT(CONVERT(F6,"kg","lbm")/14)&"st "&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb" Signature--- HTH Bob (change the xxxx to gmail if mailing direct) >I used the formula below, given elsewhere on this site to convert kilos >into [quoted text clipped - 5 lines] > round > up or down the decimals so that the result would show 15st 6lb. All the above works great. Thanks top everyone for thier assistance. >=INT(CONVERT(F6,"kg","lbm")/14)&"st >"&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb" [quoted text clipped - 4 lines] >> round >> up or down the decimals so that the result would show 15st 6lb. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.