夏普比率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