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