| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Find the balance of amount from a total count of 60....
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Find the balance of amount from a total count of 60....
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. 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find all employees whose total salaries equal a given amount | Excel Discussion (Misc queries) | |||
| how do i have beginning balance take away an amount auto total | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
| a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
Linear Mode
