How to Find Percentage of Two Numbers in Excel

To find the percentage of two numbers in Excel, you can use the formula:

Percentage = (Part / Whole) * 100

Here's how to do it with Excel:

1. Open a new Excel workbook or worksheet.
2. In cell A1, enter the part (the smaller number). For example, if you want to find the percentage of 50 out of 200, enter 50 in cell A1.
3. In cell B1, enter the whole (the larger number). In our example, enter 200 in cell B1.
4. In cell C1, enter the formula to calculate the percentage: =(A1/B1)*100
5. Press Enter. The result will appear in cell C1, showing the percentage of the two numbers.

Example

Let's say you want to find the percentage of students who passed an exam. There were 150 students who took the exam, and 120 of them passed.

1. In cell A1, enter the number of students who passed the exam: 120
2. In cell B1, enter the total number of students who took the exam: 150
3. In cell C1, enter the formula to find the percentage: =(A1/B1)*100
4. Press Enter. The result will appear in cell C1, showing the percentage of students who passed the exam. In this case, it would be 80%.