Excel fractions miscalculated

Question

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?

Answer 1

@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.