how do i get the formula in excel to work out what percentage one number is of another, e.g

what percentage is 6769 of 8750

Let's say Cell A1 is your Input Value:

A1: 6769Cell B1 will be your Total Value:

B1: 8750Type the following into Cell C1:

=A1/B1Now Format C1 as Percentage.

* Right-Click C1.

* Format Cells.

* On the "Numbers" tab, Click on "Percentage".

* Modify your "Decimal Places", if needed.

* Click on "OK".Cell C1 should now show:

77.36%

Ask Your Question

Weekly Poll