I want to calculate the ratio of two values and present it in the form
x : y

I then want to multiply that ratio by 1 : 2 and present the answer in
the form x : y

thanks.

do you mean like
x= 7
y=5
z = x /y
msgbox "1:" & z



"Gareth Wretham" <(E-Mail Removed)> wrote in message
news:e94d3740-bdd9-4794-ac2b-(E-Mail Removed)...
> I want to calculate the ratio of two values and present it in the form
> x : y
>
> I then want to multiply that ratio by 1 : 2 and present the answer in
> the form x : y
>
> thanks.

On Jun 9, 10:19*am, "Patrick Molloy" <patrick_mol...@hotmail.com>
wrote:
> do you mean like
> x= 7
> y=5
> z = x /y
> msgbox "1:" & z
>
> "Gareth Wretham" <gareth.wret...@gmail.com> wrote in message
>
> news:e94d3740-bdd9-4794-ac2b-(E-Mail Removed)...
>
>
>
> > I want to calculate the ratio of two values and present it in the form
> > x : y
>
> > I then want to multiply that ratio by 1 : 2 and present the answer in
> > the form x : y
>
> > thanks.- Hide quoted text -
>
> - Show quoted text -

yes - and then how do I multiply that ratio by 1:2?

eg, if the first ratio is 1:3 then it becomes 1:6 when multiplied by
1:2

Extending Patrick's code:

msgbox "1 : " & z
msgbox "1 : " & z * 2


"Gareth Wretham" wrote:

> On Jun 9, 10:19 am, "Patrick Molloy" <patrick_mol...@hotmail.com>
> wrote:
> > do you mean like
> > x= 7
> > y=5
> > z = x /y
> > msgbox "1:" & z
> >
> > "Gareth Wretham" <gareth.wret...@gmail.com> wrote in message
> >
> > news:e94d3740-bdd9-4794-ac2b-(E-Mail Removed)...
> >
> >
> >
> > > I want to calculate the ratio of two values and present it in the form
> > > x : y
> >
> > > I then want to multiply that ratio by 1 : 2 and present the answer in
> > > the form x : y
> >
> > > thanks.- Hide quoted text -
> >
> > - Show quoted text -
>
> yes - and then how do I multiply that ratio by 1:2?
>
> eg, if the first ratio is 1:3 then it becomes 1:6 when multiplied by
> 1:2
>
>

to close this thread, the solution was really just a spreadsheet one:

sumtotal = (hoursA * unitsA) + (hoursB * unitsB) => (50x2)+(100*1) => 200

Atotal = (hoursA * unitsA) /sumtotal *100% => ( (50x2)/200 ) x 100 = 50%
Btotal = (hoursB * unitsB) /sumtotal *100% => ( (100x1)/200 ) x 100 = 50%


"JLatham" <(E-Mail Removed)> wrote in message
news:A65BB33E-2105-4A6C-8899-(E-Mail Removed)...
> Extending Patrick's code:
>
> msgbox "1 : " & z
> msgbox "1 : " & z * 2
>
>
> "Gareth Wretham" wrote:
>
>> On Jun 9, 10:19 am, "Patrick Molloy" <patrick_mol...@hotmail.com>
>> wrote:
>> > do you mean like
>> > x= 7
>> > y=5
>> > z = x /y
>> > msgbox "1:" & z
>> >
>> > "Gareth Wretham" <gareth.wret...@gmail.com> wrote in message
>> >
>> > news:e94d3740-bdd9-4794-ac2b-(E-Mail Removed)...
>> >
>> >
>> >
>> > > I want to calculate the ratio of two values and present it in the
>> > > form
>> > > x : y
>> >
>> > > I then want to multiply that ratio by 1 : 2 and present the answer in
>> > > the form x : y
>> >
>> > > thanks.- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> yes - and then how do I multiply that ratio by 1:2?
>>
>> eg, if the first ratio is 1:3 then it becomes 1:6 when multiplied by
>> 1:2
>>
>>