Converting values into ounces

[pborgbarthet]

Good Evening.

I have a long list of values corresponding to a quantity of color put into paint. I need to convert these according to paint size (1ltr, 2.5ltr, 5ltr etc.) However, once the number of drops reaches 48, I need this to translate to 1 (oz).

In other words;

5 x 10 = 50.. this would display as 1 oz 2 (48 = 1oz + 2 remainder)

or

20 x 5 = 100.. this would display as 2 oz 4 (96 = 2oz + 4 remainder)

Is there a way I could do this, either by formula or by macro?

Thanks in advance to anyone who could help me out!

 

[MickG]

Perhaps:-
"A" = Data, "B"= Results , "C" formula in "B"

[COLOR=RoyalBlue][B]Row No [/B][/COLOR] [COLOR=RoyalBlue][B]Col(A) [/B][/COLOR] [COLOR=RoyalBlue][B]Col(B)              [/B][/COLOR] [COLOR=RoyalBlue][B]Col(C)                                             [/B][/COLOR]
1.      50      1 oz  + 2 Remainder  =INT(A1/48) &" oz  + " & MOD(A1,48) & " Remainder" 
2.      100     2 oz  + 4 Remainder  =INT(A2/48) &" oz  + " & MOD(A2,48) & " Remainder" 
3.      48      1 oz  + 0 Remainder  =INT(A3/48) &" oz  + " & MOD(A3,48) & " Remainder"

Regards Mick

 

[pborgbarthet]

That is perfect.. exactly what I needed. Thanks a lot, you're a genius!

 

[MickG]

You're welcome