I am preparing reports for my students. Column F6 features their grade out of seventy.
Can someone explain very simply how I can just imput this score and have it automtically chane to a percentage?
I'll be needing step by step instructions - I'm not so bright.
2006-07-05 01:26:09 · 11 answers · asked by brendanconnal 1 in Computers & Internet ➔ Software
Click the cell. Right click your mouse. Select the format cell. Window ill pop out, then you can select which format you needs.
2006-07-05 01:31:33 · answer #1 · answered by zamora_maricel 1 · 0⤊ 0⤋
Hopefully column G is empty. If not, use the next available column.
Let's say the 1st score out of 70 is in F6. Highlight G6 and type =F6/70 then press Enter
Highlight G6 again and click on the % sign you should find in one of your toolbars. This will change the value to a percentage figure.
Highlight G6 again and move the mouse to the bottom right hand corner of the cell until the cursor becomes a + in black. While it's like that, drag the mouse down column G until all the values in column F have percentages for them.
2006-07-05 01:37:26 · answer #2 · answered by FontOfNoKnowledge 3 · 0⤊ 0⤋
The way that I would suggest would be to have to conversion happen in the next column. You would input the following =A6/70*100 (where A6 is the cell with the mark in it.) You would then highlight the all rest of the cells in the columnn including the one with the formula and go Edit Menu, select fill>down to put the formula in all of the cells. By this method you will have colum F6 which will still show all of the scores and column F7 which will show the score as a percentage.
2006-07-05 01:38:36 · answer #3 · answered by jaybird 4 · 0⤊ 0⤋
You may enter the mark in f5 (or any other column) as eg. 30 if that's the mark out of 70, and then place a formula in f6 using the following steps :
(1) select f6 and type =f5*100/70, then hit the enter key.
(2) any figure you now type in f5 will show as a percentage in f6.
Hope this helps.
2006-07-05 01:44:48 · answer #4 · answered by coolzadar 2 · 0⤊ 0⤋
In a separate column of the table, type in this formula +((F6/70)/7)*10 . Format the cells in that column so that the number format is in percentage.
2006-07-05 01:33:09 · answer #5 · answered by k² 6 · 0⤊ 0⤋
In the column to the right of the cell containing their score out of 70 type:
=F6*100/70.
2006-07-05 01:31:54 · answer #6 · answered by Folded Paper Figures 2 · 0⤊ 0⤋
To get a cell with the percentage calculated you need to write in the cell you want the results: =F6/70 then, with the cell(s) sellected, press
2006-07-05 01:32:46 · answer #7 · answered by synthetic 3 · 0⤊ 0⤋
right click on the cell and choose format cell and change on the list from general to number and on the right column scroll down to percentage
from then on all values in that cell will be %s or u can select a whole row/column to apply the same idea top a whole row/column
2006-07-05 01:32:16 · answer #8 · answered by greg_cristal 4 · 0⤊ 0⤋
I answered one of your other questions about Excel. I am also a teacher, and I just learned last year of a super web site that has a free program.
It is called Gradekeeper, and looks like Excel, but is easy to keep grades and such, create reports, etc. The link is below.
2006-07-05 21:27:35 · answer #9 · answered by powhound 7 · 0⤊ 0⤋
Are the numbers to the excellent of the / character constantly one digit in length? if so, paste this formulation in D16 =SUMPRODUCT((N(precise(A1:A1000, a million)=precise(D15,a million)))*(B1:B1000)) in the journey that your records is going previous row 1000, replace the thousands to a pair huge form bigger than what you have. The above formulation assumes all your records in column A starts off with g/z.
2016-12-10 04:48:03 · answer #10 · answered by ? 4 · 0⤊ 0⤋