Calculating Dozens

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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
 
Back
Top