Thank you very much!!
"RagDyeR" wrote:
Enter 75 in say Y1 (out of the way area).
Say names in Column A, A2:A50
Points in Column B, B2:B50
Enter this formula in C2:
=(B2<"")*$Y$1*B2
And copy down as needed.
Where you can simply change the value in Y1, which will automatically change
*all* the formulas.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"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
|