Calculating and multiplying ratios

  • Thread starter Thread starter Gareth Wretham
  • Start date Start date
G

Gareth Wretham

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








- Show quoted text -
Click to expand...

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%
 
Back
Top