# Really stuck on percentages

#### Albionchez

##### New Member
Hi All, new to this so please bear with me.

I have to create a very simple spreadsheet that shows an accuracy rate but I cant figure out how to do it.

I have a number of questions taken (50) and I also have a number of questions answered wrong (42), is there anyway that I can show the number of questions answered correctly (8) as a percentage in another cell??

It spunds so easy but I cant think of a way to do it!!

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hi All, new to this so please bear with me.

I have to create a very simple spreadsheet that shows an accuracy rate but I cant figure out how to do it.

I have a number of questions taken (50) and I also have a number of questions answered wrong (42), is there anyway that I can show the number of questions answered correctly (8) as a percentage in another cell??

It spunds so easy but I cant think of a way to do it!!

Lets say your number of wrong questions is in cell A1

=(50-A1)/50

Then format the cell as a percentage.

If your number of questions changes, you could also put that number in a cell... lets say A2. Then it becomes

=(A2-A1)/A2

Lets say your number of wrong questions is in cell A1

=(50-A1)/50

Then format the cell as a percentage.

If your number of questions changes, you could also put that number in a cell... lets say A2. Then it becomes

=(A2-A1)/A2

That works perfectly. Thanks a lot. Next question is what if these numbers change is there a way of updating the numbers in the formula automatically rather than going in and inputting the data every time?

Again many thanks

Replies
3
Views
155
Replies
7
Views
224
Replies
0
Views
180
Replies
4
Views
119
Replies
0
Views
99

1,203,757
Messages
6,057,178
Members
444,911
Latest member
Uncommon1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back