Working out aspect ratios in Excel

Aspect Ratios in ExcelI’ve spent most of my time at work recently building a big ol’ database with specifications of screens. Once the structure had been completed, I needed to import all existing data (stored in an Excel spreadsheet) in to the database. I’ve build the database with a form where everything can be put in. Functionality of this form includes automatically calculating aspect ratios from width and height pixel dimensions – something that didn’t exist in the spreadsheet.

Here’s the Excel formula to calculate aspect ratios:


This assumes width is in A1 and height is in B1

One thing to note with this that aspect ratios of 16:10 will be displayed as 8:5. 8:5 is the correct ratio but is instead referred to as 16:10 for easier comparison against 16:9.

Learn more about GCD

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *