"Ragdyer" wrote:

Don't really understand your question.

When you say "sales mix - 1:6", where item A represents the 10,000, and item
B represents the 60,000, isn't a simple multiply by 6 - divide by 6 - rule
good enough for you?

Item A is ordered - multiply quantity by 6 to arrive at quantity for item B.

Item B is ordered - divide quantity by 6 to arrive at quantity for item A.

What am I missing here ... OR ... what have you left out of your question?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"brenflyd" wrote in message
...
I have two numbers 10,000 and 60,000 these are the units produced. I need
to
make a sales mix using ratios of 1:6 and I cannot for the life of me
figure
it out. It is probably so simple. Help please

Thanks for your help but I figured it out on my own it is an if statement.