Percentage calculations

[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?

 

[Don Guillett]

Have a look in the help index for
ABSOLUTE

 

[MartinW]

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