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
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?Answer1:
@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.
<img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/4dNxV.png" data-original="https://i.stack.imgur.com/4dNxV.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />