« Filling a multiplication chart | Main | Adding a dialog: Part I »
September 07, 2005
Formatting ratios
Sometimes, it is useful to display the result of a division as the ratio of two numbers - the dividend and the divisor.In the example below, we have assets and liabilities. We would like to display the ratio in the format x : 1 where x is assets divided by liabilities. This can be achieved by creating a custom format for the cell as shown below. The format code is 0.00" : 1"
The end result is shown below. This works under the assumption the ratio is always relative to 1.
Posted by Dave at September 7, 2005 09:06 PM