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

I'm not exactly sure what you're trying to do........10,000 is of course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific details and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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

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

"CLR" wrote:

I'm not exactly sure what you're trying to do........10,000 is of course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific details and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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


I am doing a worksheet that the ratios must change when my units change. So
I am trying to figure how to formulate the ratios. I understand that the
ratio is 1:6 and I can make it say 1 and 6 but if I change my numbers to
60,000 and 30.000 my ratios do not work

Try this...........

In A1 put your 10,000
In B1 put your 60,000
In C1 put this formula.........=A1/B1 and format the cell as a fraction
(Right-click FormatCells NumberTab Fraction UpToOneDigit(1/4)
ok)....this will display 1/6 as the ratio.

As you add data to A2, B2 etc, copy the formula down the column C to show
the new ratios.

Vaya con Dios,
Chuck, CABGx3


"brenflyd" wrote in message
...


"CLR" wrote:

I'm not exactly sure what you're trying to do........10,000 is of course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific details
and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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


I am doing a worksheet that the ratios must change when my units
change. So
I am trying to figure how to formulate the ratios. I understand that the
ratio is 1:6 and I can make it say 1 and 6 but if I change my numbers to
60,000 and 30.000 my ratios do not work

Lower number in A1, larger in B1.

Simply divide larger by smaller:

=B1/A1

60000/10000 = 6
Meaning 1:6

60000/30000 = 2
Meaning 1:2

36000/24000 = 1.5
Meaning 1:1.5
--
HTH,

RD

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


"CLR" wrote:

I'm not exactly sure what you're trying to do........10,000 is of course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific details
and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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


I am doing a worksheet that the ratios must change when my units
change. So
I am trying to figure how to formulate the ratios. I understand that the
ratio is 1:6 and I can make it say 1 and 6 but if I change my numbers to
60,000 and 30.000 my ratios do not work

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

Thanks for help with this but I figured it out with an if statement.
"CLR" wrote:

Try this...........

In A1 put your 10,000
In B1 put your 60,000
In C1 put this formula.........=A1/B1 and format the cell as a fraction
(Right-click FormatCells NumberTab Fraction UpToOneDigit(1/4)
ok)....this will display 1/6 as the ratio.

As you add data to A2, B2 etc, copy the formula down the column C to show
the new ratios.

Vaya con Dios,
Chuck, CABGx3


"brenflyd" wrote in message
...


"CLR" wrote:

I'm not exactly sure what you're trying to do........10,000 is of course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific details
and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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


I am doing a worksheet that the ratios must change when my units
change. So
I am trying to figure how to formulate the ratios. I understand that the
ratio is 1:6 and I can make it say 1 and 6 but if I change my numbers to
60,000 and 30.000 my ratios do not work

Cool..........glad you got there............

Vaya con Dios,
Chuck, CABGx3



"brenflyd" wrote in message
...

Thanks for help with this but I figured it out with an if statement.
"CLR" wrote:

Try this...........

In A1 put your 10,000
In B1 put your 60,000
In C1 put this formula.........=A1/B1 and format the cell as a fraction
(Right-click FormatCells NumberTab Fraction UpToOneDigit(1/4)
ok)....this will display 1/6 as the ratio.

As you add data to A2, B2 etc, copy the formula down the column C to
show
the new ratios.

Vaya con Dios,
Chuck, CABGx3


"brenflyd" wrote in message
...


"CLR" wrote:

I'm not exactly sure what you're trying to do........10,000 is of
course
1/6th of 60,000 or a ratio of 1:6.

If you have a component of the 10,000 sum and want to equate it to
the
60,000 sum, just multiply times 6.
If you have a component of the 60,000 sum and want to equate it to
the
10,000 sum, just divide by 6.

If this is not explanation enough, post back with more specific
details
and
we will be glad to help all we can.

Vaya con Dios,
Chuck, CABGx3


"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


I am doing a worksheet that the ratios must change when my units
change. So
I am trying to figure how to formulate the ratios. I understand that
the
ratio is 1:6 and I can make it say 1 and 6 but if I change my numbers
to
60,000 and 30.000 my ratios do not work

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.