Excel分数计算错误 [英] Excel fractions miscalculated

问题描述

我正在尝试在Excel中计算屏幕比例.我有一列包含x和y的列，我希望从计算出的比率列得到的示例如下:

I'm trying to calculate screen ratios in Excel. I have a column with x and y, an example of what I'd expect from the calculated ratio column is:

 x    | y    | ratio
 1920 | 1080 | 16/9

但是通过使用公式= x/y并将比率列格式化为分数，我得到了:

but by using the formula =x/y and formatting the ratio column as a fraction I get:

 x    | y    | ratio
 1920 | 1080 | 17/9

我认为这与舍入误差有关，但是为了显示准确的屏幕分辨率比率，有什么办法解决此问题?

I assume this is something to do with rounding error, but is there any way around this, in order to show accurate screen resolution ratios?

推荐答案

@pnuts是正确的.您可以使用自定义格式更改输出.右键单击该单元格，然后选择格式.然后使用以下自定义编号.

@pnuts is right. You can change the output by using a custom format. Right click on the cell and choose format. Then use the following custom numbering.

这篇关于Excel分数计算错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！