Format a ratio
 

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))

Format a ratio
 

=(C5/GCD(C5)&":"&ROUND(C5/GCD(C3),0))
--
Gary''s Student - gsnu200778

Format a ratio
 

I'm not sure what the GCD()'s are doing in your formula, but maybe...

="1:"&TEXT(C5/C3,"##")

If it doesn't help, how about sharing what's in C5 and C3?



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))

--

Dave Peterson

Format a ratio
 

what I am trying to do is get a ratio using the following example: I have 3
departments with a total of 74 employees. so the final ratio I am lookin for
is 1:25 not 1:24.67. So C5 is employees and C3 is departments/managers

"Dave Peterson" wrote:

I'm not sure what the GCD()'s are doing in your formula, but maybe...

="1:"&TEXT(C5/C3,"##")

If it doesn't help, how about sharing what's in C5 and C3?



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))

--

Dave Peterson

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))

Format a ratio
 

So did the suggested formula work?

USD305 wrote:

what I am trying to do is get a ratio using the following example: I have 3
departments with a total of 74 employees. so the final ratio I am lookin for
is 1:25 not 1:24.67. So C5 is employees and C3 is departments/managers

"Dave Peterson" wrote:

I'm not sure what the GCD()'s are doing in your formula, but maybe...

="1:"&TEXT(C5/C3,"##")

If it doesn't help, how about sharing what's in C5 and C3?



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))

--

Dave Peterson


--

Dave Peterson