Excel spreadsheet for postage calculation?

Question

I am trying to create an Excel spreadsheet to compute the number of first-ounce and additional-ounce postage stamps for envelopes.  

Here is how far I have got:

 

In the red cell A2 I type the weight of the envelope in ounces.   In this example, my envelope weights twelve ounces.  Row 1 then tells me the monetary value of postage that the envelope needs.

Row 4 then reports the number of first-ounce stamps that I need.  Row 4 reports these numbers as decimals.

What I want to do is separate those numbers in Row 4 between the first-ounce and the additional-once stamps.  In the present example, I would like Cell B4 to report “5” and Cell B5 to report the number of additional-ounce stamps.   In the present example, “.2” would be “1” additional-ounce stamp.   

Continuing the example, if I enter “13” in A2, B4 goes to “5.6.”   That would be five first-ounce stamps and two additional-ounce stamps.   

I would like to get the spreadsheet to perform these conversions from decimals to whole numbers.

Does anyone have formulae for these computations?

Answer 1

You are welcome. You can also give feedback on it.

Answer 2

Thanks!

Answer 3

B4

=ROUNDDOWN(B2/0.63,0)

B5

=ROUNDUP((B2-B4*0.63)/0.24,0)

Best Reagrds,

Snow Lu