Hello,

I have a formula to calculate the ratio between 2 cells. here it is:
=AF3/GCD(AF3:AI3) & ":" & AI3/GCD(AF3:AI3)

the problem is that it gives the ratio in its simplest form. e.g. cell AF3=15 and cell AI3=30,
the answer would be 1:2.
I want it to be 15:30

Thanks