Ratiios in Excel

[redwhiteandblueblooded]

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.

[Jimmy_041]

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?

[smac]

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

Good discussion here, multiple excel version solutions discussed.

[redwhiteandblueblooded]

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.

[redwhiteandblueblooded]

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.