Hi

P.e. you have points in A1
Into cell, you want to display value in pounds in, eter the formula
=A1*75
and format as currency.

Arvi Laanemets


"Victoria" wrote in message
...
Hi

I would be very grateful for help in the following:
I am creating a spreadsheet which I want to update on a weekly basis. I
would like to be able to make a point have a value i.e.

1 point = £75.00

I would like to reference the cell so that when I enter increased points
in
one cell
it will show the value in pounds in another cell and update whenever there
is a change.

I am sure that I have done this before (absolute referencing with interest
rates??)
Can anyone point me in the right direction? Thanks in advance