The marks are out of 25, 20, and 8. I would like the spreadsheet to make a total mark out of 55 and then give me a percentage.
I don't know how to tell the spreadsheet to fill in (D + E + F) / 55 .... please help!How can I calculate the percentage of these three marks in a student spreadsheet?
Your question's a bit unclear... not sure what it is you're trying to calculate. If you want to add in a column use the command =sum(B1:B10) with B being the column you're adding and 1:10 being the rows that would add up.
If what you said above means you want to know what percent 25, 20 and 8 are out of 55 then the formula for each of those marks would be =sum(A1/55) with A1 being the cell that 25 is listed in, for example. In this cell where you put the sum command you would right click, select "Format" and then "Percentage" so that it would display 45% as opposed to .45 for the answer.How can I calculate the percentage of these three marks in a student spreadsheet?
in the cell where you want the average put this
=Sum(Cell1+Cell2+Cell3)/55
Cell1 2 3 obvoiusly will be the cell references.
If I read your question right. If not, feel free to email me.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment