Return and convert a result from a decimal number to two different units

[Nicholas Petti]

I created a liquor inventory spreadsheet that calculates the items based on weight. This way in doing inventory, I have only to weigh each partial bottle, enter the weight and the formula will add the partial weight to the weight of the full bottles and return a total weight. By having my starting inventory stated as full bottles + partial bottles, then adding the weight of full bottles received, then subtracting the weight of full bottles, glass, and half glasses sold, I arrive at what my closing inventory should be. This part is all fine, I've got all the necessary formulas in place.

What I want to achieve is to break my ending total weight into full bottles and remaining ounces. i.e. my ending inventory is say, 335.25 oz which equals 13 full bottles (329.55 oz) and 5.7 oz. If I just divide my ending weight (335.25) by 25.35 (bottle weight in oz) I get 13.224852071. How do I get the decimal to show as number of ounces, rather than fraction of the 25.35?

Thanks in advance for your help.

<colgroup><col width="107"></colgroup> <tbody>
</tbody>

 

[JoeMo]

Excel Workbook
	A	B	C
1	#Bottles	FulL Bottles	Oz
2	13.22485207	13	5.7
Sheet5

 

[ChrisM]

=INT(H9/I9)+(MOD(H9,I9)*0.01)

will give 13.057

 

[Nicholas Petti]

Perfect! Thank you so much for helping. If you ever stop by, I'll buy you a drink.

Sheet5

*	A	B	C
1	#Bottles	FulL Bottles	Oz
2	13.22485207	13	5.7

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:84px;"><col style="width:79px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B2 =INT(A2) C2 =MOD(A2,1)*25.35 <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[JoeMo]

Perfect! Thank you so much for helping. If you ever stop by, I'll buy you a drink.

OK but MOD(13.0394477317554,1)*25.35 ounces is all I can handle at my age.