Percentage calculations

  • Thread starter Thread starter Deltic
  • Start date Start date
D

Deltic

I need to design a sheet that has along the top 1 - 50 (number of
questions in the paper) and down the side has 1 - 50 (number of
questions answered correctly). Is there a way of filling in the graph
without going to each cell and entering the formula one at a time, for
instance the first cell would be B1/A2*100 and so on. I have tried but
cannot get the correct formula to use, can you help?
 
Hi Paul,

Your formula is back to front to your stated data.

It should be
=A2/B1*100

To lock it for dragging
=$A2/B$1*100

Then add a checker to stop it from going over 100
=IF($A2/B$1*100>100,"",$A2/B$1*100)

HTH
Martin
 
Back
Top