Solved excel percentages

July 13, 2010 at 09:37:33
Specs: Windows XP
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

See More: excel percentages

July 13, 2010 at 12:35:05
✔ Best Answer
Let's say Cell A1 is your Input Value:
A1: 6769

Cell B1 will be your Total Value:
B1: 8750

Type the following into Cell C1:

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

Report •
Related Solutions

Ask Question