I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th
row. How do I do this in Excel 2000?

=INDIRECT("B"&60-A30)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jsp377" wrote in message
...
I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th
row. How do I do this in Excel 2000?

Bob:
Not sure I understand what OP has asked here, but
when I test things out I had to use
=INDIRECT("B"&60)-A30
to get my cell to return a value other than #REF!
Jim


"Bob Phillips" wrote in message
...
=INDIRECT("B"&60-A30)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jsp377" wrote in message
...
I'm trying to reference a cell using other cells, for example:
B(60-A30),
which is to mean reference the cell in the Bth column, and the
(60-A30)th
row. How do I do this in Excel 2000?

Hi Jim,

I was reading it that A30 had a numeric value in it, and the OP wanted the
cell column B, row 60 less the value in A30, otherwise why not just use
B60-A30? If you put 40 say in A30, and a value in B20, it works.

I must admit it was unclear though, and I wondered whether A30 referred to
the cell value or whether he wanted to subtract 30? I thought about adding
some question marks, but thought this might be interpreted that I was unsure
whether INDIRECT was the right function, which I was quite sure about.

The glories of language <g.

Regards

Bob


"Jim May" wrote in message
news:4F5Kd.48543$jn.48483@lakeread06...
Bob:
Not sure I understand what OP has asked here, but
when I test things out I had to use
=INDIRECT("B"&60)-A30
to get my cell to return a value other than #REF!
Jim


"Bob Phillips" wrote in message
...
=INDIRECT("B"&60-A30)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jsp377" wrote in message
...
I'm trying to reference a cell using other cells, for example:
B(60-A30),
which is to mean reference the cell in the Bth column, and the
(60-A30)th
row. How do I do this in Excel 2000?