夏普比率excel_在Excel中计算比率

夏普比率excel

In Excel, if you divide 2 by 8, the result is 0.25. If you format the cell as a fraction, the cell might show 1/4 as the result. But how can you calculate a ratio in Excel? See the steps below.

在Excel中，如果将2除以8，则结果为0.25。 如果将单元格格式化为小数，结果单元格可能会显示1/4。 但是如何在Excel中计算比率？ 请参阅以下步骤。

Here's a worksheet with 2 divided by 8, with the result showing as a ratio, in cell D2, and as a decimal number in cell D4.

这是一个工作表，其中2除以8，结果在D2单元格中以比率显示，在D4单元格中以十进制数显示。

视频：在Excel中显示比率 (Video: Show a Ratio in Excel)

Watch this short video