Really stuck on percentages

[Albionchez]

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

Thanks for any help you can give.

 

[BAlGaInTl]

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

Thanks for any help you can give.

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

 

[Albionchez]

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