Calculate raito as 1 in 4 not 4 in 1

[WISEKATTY]

Hi hoping someone can help.

I am trying to calculate the number of sales per leads. These are the formulas I have tried.

=IF(($X12)=0,"",$X12/GCD($X12,$W12) & ":" & $W12/GCD($X12,$W12))

This function works if the cells divide by each other equally i.e. leads 6, sales 2 = 1:3

However most do not divide equally. i.e. 24 leads, 5 sales = 5:24 I need it to be 1:5

If I use =IF(x12=0,0W9/X9) and set the cell format to "0:1" the result is 5:1 it has to be 1:5

I have spent hours trying to figure this out, any help would be appreciated.

[daddylonglegs]

Does the ratio always have to be 1 to something.....? If so then try

="1:"&ROUND(W12/X12,0)

if not can you give some more examples.....

[WISEKATTY]

You are a legend, thank you so much - this has been driving me nuts....