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

#### Nicholas Petti

##### New Member
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?

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

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Excel Workbook
ABC
1#BottlesFulL BottlesOz
213.22485207135.7
Sheet5

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

will give 13.057

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>

 Cell Formula B2 =INT(A2) C2 =MOD(A2,1)*25.35

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

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.

Replies
2
Views
7K
Replies
1
Views
355
Replies
3
Views
1K

1,203,070
Messages
6,053,363
Members
444,657
Latest member
jessejames1of3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back