Calculation to replace the cell contents

[Dave Neve]

Sorry to ask such basic questions but I only use Excel once a year for end
of term marks.

I have a column with results /82 eg; 56, 27, 49 (all out of 82)

I want to convert the mark to /20 (out of 20) and for the results to replace
the marks out of /82.

So the formula should be mark/82 x 20 = mark out of 20

Could sm tell me apply this formula so that Excel will recalculate the
column for me?

Thanks in advance

 

[Guest]

Hi Dave:

You want to scale numbers in place:

1. in an un-used cell enter =20/82
2. copy this cell
3. select all the cells in the column you wish to re-scale
4. pull-down:
Edit > Paste Special... > and check the multiply button.

Have a pleasant day !

 

[Dave Neve]

Hi

Unfortunately, nothing happens.
Could I be missing sth here.

 

[Paul Lautman]

Hi

Unfortunately, nothing happens.
Could I be missing sth here.

Well the only thing missing from Gary's Student's instructions was to press
OK after checking the multiply button.
Apart from that it works fine for me, so I guess you must be missing
something as everything else is there.