I'm trying to write a spreadsheet to calculate the pounds and ounces of different foods to feed my dog, cat, and kitten, based on their weight.
In this thread Marcol helped another poster with a spreadsheet for figuring weights of fish, but when I opened it, the formulas would not display.
Attached is my spreadsheet so far. It's got values in kilograms but my scale only weighs pounds and ounces.
Thanks for helping!
Does this work for you?
=INT(C3*2.20462262)& " Lbs "&ROUND(MOD(C3*2.20462262,1)*16,0)&" ounces"
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In J11,
=DOLLARFR(MROUND(CONVERT(H11, "kg", "lbm"), 1/16), 16)
... returns 1.04, meaning 1 lb 4 oz
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks