Find the balance of amount from a total count of 60....

  • Thread starter Thread starter Krishna Kumar L
  • Start date Start date
K

Krishna Kumar L

Hello,

I have a strange problem... I calculate some products with 60 as one part... Eg. One box contains 60 pieces and i sell products in dozens and also pieces. I need Excel to calculate the balance and give in numbers. I am not able to get the figure right.
 
Hi Krishna,
I have a strange problem... I calculate some products with 60 as one
part... Eg. One box contains 60 pieces and i sell products in dozens
and also pieces. I need Excel to calculate the balance and give in
numbers. I am not able to get the figure right.
Click to expand...

If the number is in cell A1...

=INT(A1/12) gives the number of even dozens
=MOD(A1,12) gives the remainder in pieces

You can combine if you want, like this...
=TEXT(INT(A1/12),0) & " doz and " & TEXT(MOD(A1,12),0) & " units"

Does this help?

Ed Ferrero
www.edferrero.com
 
Back
Top