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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
news:[email protected]...
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

Thank you soooo much - I'm embarrassed it was that easy!!

"Arvi Laanemets" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>