Format a ratio
Thank you for getting me up and going!
"USD305" wrote:
I am using the following formula to calculate a ratio but the problem that I
am running into is that the final answer turns out to be 1:20.665478 and I
need to format it to be 1:21.
=(C5/GCD(C5)&":"&C5/GCD(C3))
|