Calculation to replace the cell contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Neve - 13 Jun 2006 10:03 GMT

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

Reply to this Message

Gary''s Student - 13 Jun 2006 10:19 GMT

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 !

Signature

Gary's Student

> Sorry to ask such basic questions but I only use Excel once a year for end
> of term marks.
[quoted text clipped - 10 lines]
>
> Thanks in advance

Reply to this Message

Dave Neve - 13 Jun 2006 12:29 GMT

Hi

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

> Hi Dave:
>
[quoted text clipped - 24 lines]
>>
>> Thanks in advance

Reply to this Message

Paul Lautman - 13 Jun 2006 13:10 GMT

> 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.

> "Gary''s Student" <GarysStudent@discussions.microsoft.com> a écrit
> dans le message de news:
[quoted text clipped - 29 lines]
>>>
>>> Thanks in advance

Reply to this Message