AD,
If you want an integer ratio:
="1:" & Round(1/(Some formula here that returns a decimal number less
than 1),0)
Or
="1:" & Round((Some formula here that returns a decimal number greater
than 1),0)
If you want decimal ratios, then remove the rounding.
HTH,
Bernie
MS Excel MVP
