How do I compute ratios?

[Guest]

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]

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

 

[Ragdyer]

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?

 

[Guest]

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





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

 

[CLR]

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

 

[Ragdyer]

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

 

[Guest]

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?

 

[Guest]

Thanks for help with this but I figured it out with an if statement.

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

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 !
---------------------------------------------------------------------------

- !
-

statement.