Ratio's

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hello all

This is extremely annoying!!!!

I am using the count function for to count #of days work
was completed. than another to count errors.

so

one example I have in cell A5-9 and in cell B5-2. This
equals 22% but I want it shown as 9:2. This can be
different of each individual

Any Ideas.

Aaron
 
Hi

not sure if there's a better way but this works on the ones i tested

=IF(A5>B5,IF(MOD(A5,B5)>0,A5&":"&B5,(A5/B5)&":"&1),IF(A5=B5,"1:1",IF(MOD(B5,
A5),A5 &":" &B5,1&":"&(B5/A5))))

Cheers
JulieD
 
I was able to accomplish this with the CONCATENATE formula
and round function. But the problem is that this does not
find the least common denominator. 16/10 should be 8:5
not 16:10. Im about ready to give up
 
I was able to accomplish this with the CONCATENATE formula
and round function. But the problem is that this does not
find the least common denominator. 16/10 should be 8:5
not 16:10. Im about ready to give up
Click to expand...
 
a search of google turned up this post:
http://groups.google.com/[email protected]
********
I don't think you can do this with a Number Format.
Here is a worksheet formula that seems to do the trick.
It uses the GCD function from the Analysis Tool Pack.

=(A2/GCD(A2,B2)&":"&B2/GCD(A2,B2))

Hope this helps,
James dot Becker at NCR dot com
*********

Cheers
JulieD
 
Back
Top