How to find the percentage of two numbers in Excel

You can watch a video tutorial here.

Excel is frequently used for calculations and supports all basic mathematical operations.  Here we will see how to find the percentage of two columns of numbers.

Step 1 – Find the ratio of the numbers

– In the destination cell type the formula:

=<number 2>/<number 1>

Step 2 – Format the number as a percentage

– Select the cell with the value
– Go to Home > Number
– Click on the percentage sign (%)
OR
Open the Format Cells window (Home > Number  and click on the arrow to expand the menu
OR Right-click and select Format Cells  from the context menu OR Go to Home > Cells > Format > Format Cells) and select Number > Percentage and click OK

Step 3 – Copy the formula

– Using the fill handle from the first cell, drag the formula to the remaining cells
OR
a) Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
b) Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)