Appreciate the feed-back ... *BUT* ... It is a common practice for folks to
post the formula or procedure that they used to solve their problem with.

That way, another possible solution to a question is added to the archives
so that all may benefit, no matter how inconsequential it may seem to you at
the present time. It may help someone down the line.

Would you care to share your solution?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"brenflyd" wrote in message
...


"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.