Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF formula headache
I am trying to set up a formula in IF to calculate a figure into what I call
'STACKS' and BASKETS'. if I have a total of 6000 and I need to know how many STACKS and BASKETS i need how do I do this. I can get STACKS but I cannot get the difference if it shows 22.67 STACKS. How do I get the .67 converted into Baskets. STACKS = 9 high and product in a BASKET = 18. Any help would be greatful. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF formula headache
Have a look at the MOD function, which returns the
remainder after division. Cheers, Pete -----Original Message----- I am trying to set up a formula in IF to calculate a figure into what I call 'STACKS' and BASKETS'. if I have a total of 6000 and I need to know how many STACKS and BASKETS i need how do I do this. I can get STACKS but I cannot get the difference if it shows 22.67 STACKS. How do I get the .67 converted into Baskets. STACKS = 9 high and product in a BASKET = 18. Any help would be greatful. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF formula headache
If your answer is in cell D16, then put this in cell E16 -
RIGHT(D16) That will equal the number of baskets in .67 stacks. Mike F "Puggwash" wrote in message ... I am trying to set up a formula in IF to calculate a figure into what I call 'STACKS' and BASKETS'. if I have a total of 6000 and I need to know how many STACKS and BASKETS i need how do I do this. I can get STACKS but I cannot get the difference if it shows 22.67 STACKS. How do I get the .67 converted into Baskets. STACKS = 9 high and product in a BASKET = 18. Any help would be greatful. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF formula headache
If a stack is 9 baskets of 18 items each then I get
total = 6000 ? int(total/(9*18)) 37 ' stacks ? total mod (9*18) 6 ' remaining products to get 22 2/3 stacks, I would need 3672 products total = 3672 ? int(total/(9*18)) 22 ' stacks ? (total mod (9*18)) 108 ' 108 remainin products ? (total mod (9*18))/18 6 ' makes 6 baskets for a formula if you total product count is in F6 =TRUNC(F6/(9*18)) & " Stacks and " & TRUNC(MOD(F6,(9*18))/18) & " baskets with a remainder of " & MOD(F6,18) & " products" -- Regards, Tom Ogilvy "Puggwash" wrote in message ... I am trying to set up a formula in IF to calculate a figure into what I call 'STACKS' and BASKETS'. if I have a total of 6000 and I need to know how many STACKS and BASKETS i need how do I do this. I can get STACKS but I cannot get the difference if it shows 22.67 STACKS. How do I get the .67 converted into Baskets. STACKS = 9 high and product in a BASKET = 18. Any help would be greatful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency Headache | Excel Worksheet Functions | |||
Vlookup Headache | Excel Worksheet Functions | |||
SQL Query Headache | Excel Programming | |||
Header Headache! | Excel Programming | |||
Look up Headache | Excel Programming |