View Single Post
  #1   Report Post  
Victoria
 
Posts: n/a
Default Creating a formula using absolute referencing - I think!!

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