Calculating Dozens

[Mark]

I'm in the T-shirt business and we buy and sell our
product by the dozens.
I.e.:
154 = 12/10
17 = 1/05
How can I use a formula to display (12/10) if I plug in
the eaches (154)?

Thanks

Mark

 

[RFJ]

Assume your total figure is in cell B7 then this, I think, gives your answer

=CONCATENATE((INT(B7/12))&"/"&(B7-(INT(B7/12)*12)))

Rob