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