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" wrote in message
...
Extending Patrick's code:

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


"Gareth Wretham" wrote:

On Jun 9, 10:19 am, "Patrick Molloy"
wrote:
do you mean like
x= 7
y=5
z = x /y
msgbox "1:" & z

"Gareth Wretham" wrote in message

...



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