# Organising Excel Sheet - HELP - Scores

So I made an excel sheet to track my progress in my school's assessments and tests. so I have my test scores which I type and upload to Column 'K' and I want column L to make the calculation of per cent of column K.

Meaning that if I upload 23/30 on K2 then L2 should automatically update as 76.67% (it's 76.666... but if possible then I would prefer the rounded off figure)

Cheers
(edited 1 year ago)
Original post by Suryaraj Vimal
So I made an excel sheet to track my progress in my school's assessments and tests. so I have my test scores which I type and upload to Column 'K' and I want column L to make the calculation of per cent of column K.

Meaning that if I upload 23/30 on K2 then L2 should automatically update as 76.67% (it's 76.666... but if possible then I would prefer the rounded off figure)

Cheers

in column L copy column K [=krelevant number] and then format cells and choose % then you can set the dp you want
Original post by Muttley79
in column L copy column K [=krelevant number] and then format cells and choose % then you can set the dp you want

i'M sorry im having trobule understanding so step 1 is to go to column L and then what?
Sorry and thanks again
Original post by Suryaraj Vimal
i'M sorry im having trobule understanding so step 1 is to go to column L and then what?
Sorry and thanks again

Copy the value in column K [I can't see what row you are on so it wil be =K[row number] do tha first and you'll get the same thing then format the cell

[Later we'll copy the formula down the column]

is it what u mean? the formula (fx) just says 23/30