19952

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?

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" />

Recommend

  • Inset axes anchored to specific points in data coordinates?
  • Pandas: selecting multiple columns from one row
  • What should be the text size ratio in android for multiple density device?
  • dynamic button calling from another class
  • Extracting the two smallest values corresponding to the unique-to-the-column ID
  • Feeding gstreamer fdsrc via STDIN only produces fraction of expected result
  • Is there such a thing as static jar linking in java?
  • flex-shrink behaviour in different browsers [duplicate]
  • Where to get negative sample images for Haar training? [closed]
  • Expand header row into multiple child rows
  • Hadoop/map-reduce: Total time spent by all maps in occupied slots vs. Total time spent by all map ta
  • Displaying and sizing a grayscale from a QImage in Qt
  • Ansible syntax best practice, YAML dictionary (key: value) or equal sign (key=value)?
  • Default CUDA addition rounding mode between cuda 5.0 and 7.5
  • How to read xlsx file in an android application?
  • add two double given wrong result
  • Formatting with mako
  • How to delete column from range if cell contains specific value in VBA/Excel
  • Is a .txt file created in VB different than one I'd randomly create?
  • Jooq casting String to BigDecimal
  • why 0.1+0.2-0.3= 5.5511151231258E-17 in php [duplicate]
  • What exactly is the height of modalPresentationStyle - FormSheet on iPad?
  • Picasso Taking time to load images
  • calculating number of bytes of each row in an image
  • Excel distinct count with conditions
  • Cross platform UI spacing/padding
  • How to draw a line dynamically in android [duplicate]
  • Blackberry 6: how to detect a long click on track pad?
  • Python cosine function precision [duplicate]
  • cordova is not defined - cordova.js has already been loaded :: Ionic
  • jQuery: add elements until a particular height is reached
  • Application level floating views with navigation in Android
  • Combining two different ActiveRecord collections into one
  • how does System.Web.HttpRequest::PathInfo work?
  • AndEngine Applying Transparancy to AndEngine View
  • Using a canvas object in a thread to do simple animations - Java
  • How to use carriage return with multiple line?
  • Avoid links criss cross / overlap in d3.js using force layout
  • NetLogo BehaviorSpace - Measure runs using reporters
  • Buffer size for converting unsigned long to string