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 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
>
>
> "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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
>
>
> "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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> >
> > "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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > >
> > > "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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
news:[email protected]...
>
>
> "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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks