How do I caclculate a ratio where the outcome is X to 1
Is it always "X to 1"? in that case you can use this custom number format
# "to 1"
If this is not what you, then give some more examples please.
"djerome" wrote:
I am trying to do some ratio analysis on some of our trusts. The way I want
the ratios to appear in the screen is "X to 1" X being integer result of my
formula. I have been able to go into custom format and get .29 to 1 where I
want it to show 29 to 1.
Any help would be greatly appreciated.
|