Calculation to replace the cell contents

D

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
 
G

Gary''s Student

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 !
 
P

Paul Lautman

Dave said:
Hi

Unfortunately, nothing happens.
Could I be missing sth here.
Click to expand...
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.
 
Top