View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ukmale65000 ukmale65000 is offline
external usenet poster
 
Posts: 1
Default Percentage calculations

I have a spreadsheet where row 2 is a series of numbers (total
questions on paper) and column 2 is another set of numbers (total
questions answered correctly) forming a grid. I can get the percentage
figure by using b2/f2*100 and it works fine but is there a way to
automatically fill in the rest of the sheet with a formula or is it a
case of me typing an individual formula in each cell?
As you can probably tell im not that good at this so step by step
instructions would be appreciated.

Thanks in advance