# 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:

- Open a new Excel workbook or worksheet.
- 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.
- In cell B1, enter the whole (the larger number). In our example, enter 200 in cell B1.
- In cell C1, enter the formula to calculate the percentage:
`=(A1/B1)*100`

- 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.

- In cell A1, enter the number of students who passed the exam:
`120`

- In cell B1, enter the total number of students who took the exam:
`150`

- In cell C1, enter the formula to find the percentage:
`=(A1/B1)*100`

- 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%.

Did you find this useful?