SA Footy

Does anyone know if there is a specific ratio function in Excel 2010. I am doing a Financial Performance assignment and the ratios need to be presented on an Excel spreadsheet. The straight calculations are fine, but how do I get the result presented in ratio form in the reslt cell?
Any help would be appreciated.

redwhiteandblueblooded wrote:Does anyone know if there is a specific ratio function in Excel 2010. I am doing a Financial Performance assignment and the ratios need to be presented on an Excel spreadsheet. The straight calculations are fine, but how do I get the result presented in ratio form in the reslt cell?
Any help would be appreciated.

Do you mean as a percentage?

http://stackoverflow.com/questions/4729 ... -format-ab

Good discussion here, multiple excel version solutions discussed.

Jimmy_041 wrote:

redwhiteandblueblooded wrote:Does anyone know if there is a specific ratio function in Excel 2010. I am doing a Financial Performance assignment and the ratios need to be presented on an Excel spreadsheet. The straight calculations are fine, but how do I get the result presented in ratio form in the reslt cell?
Any help would be appreciated.

Do you mean as a percentage?

No, as in .86:1. The formula for caclulating the 0.86 is easy, but then getting it to display in ratio format in the target cell is driving me nuts.

smac wrote:http://stackoverflow.com/questions/472989/how-do-i-display-a-ratio-in-excel-in-the-format-ab

Good discussion here, multiple excel version solutions discussed.

thanks mate. some good stuff here.