How to write ratios in Excel.

We will use a sample data set with two columns, Column A and Column B, to demonstrate ratio calculations. The values in Column B correspond to the denominator, while those in Column A correspond to the numerator. The ratio of each numerator value to its corresponding denominator value, expressed in the form A: B, is what we want to display in a third column.

Microsoft Excel is a robust spreadsheet program with a number of features for analyzing and manipulating data. The calculation and presentation of ratios is one practical use of Excel. Ratios enable quick comparisons by shedding light on the connections between various data points. This step-by-step documentation will walk you through the process of writing ratios in Excel, giving you the ability to express proportional relationships in an organized, clear manner.

Step 1 – Open the Spreadsheet:

– Open Microsoft Excel.
– Navigate to the spreadsheet containing the data set.

Step 2 – Select the cell where you want to display the output:

– Choose the cells in which you want to show the ratios.
– In this instance, let’s say Column C, we will create the ratios in a new column.

Step 3 – Enter the formula:

– Enter the following formula in the first cell (C1) of the new column: 
– Here, the outcome of the division of A1/B1 is transformed into an improper fraction using the TEXT function.
– The fraction’s “/” is changed to a colon (“:”) using the SUBSTITUTE function.
– To apply the formula to the first cell, press Enter.

Step 4 – Apply the formula to the remaining cells:

– Now the first row’s ratio is computed. There are two ways to apply the formula to the remaining rows.
Double-click the small square in the cell marked C1‘s bottom right corner. This will automatically adjust the cell references and copy the formula to the remaining cells in Column C.
– Or you can, select the range of cells in Column C where you want to apply the formula, copy the formula (C1), and then paste the formula into the chosen cells.


You have successfully written ratios in Excel by following these steps. The ratios of each numerator value to its corresponding denominator value are now shown in the newly created Column C in the desired format of A:B. The convenience of performing calculations and presenting data in different formats made possible by Excel’s built-in functions allows for effective analysis and the visual representation of proportional relationships.