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