ExcelBanter - References to cells in formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - References to cells in formulas (https://www.excelbanter.com/excel-discussion-misc-queries/113998-references-cells-formulas.html)

[email protected]

References to cells in formulas

I have data in cell a1, I need a formula like d1 = b1+c1
I want b1 to point to a1 by reference only.

I just want to be able to enter a1 into b1 to get the value.
I do not want =a1 in cell b1.

JMB

References to cells in formulas

NG said an error occurred - so I'll post again

try

=INDIRECT(B1)+C1

where B1 contains "A1" (w/o the quotes)

" wrote:

I have data in cell a1, I need a formula like d1 = b1+c1
I want b1 to point to a1 by reference only.

I just want to be able to enter a1 into b1 to get the value.
I do not want =a1 in cell b1.

JMB

References to cells in formulas

try

=INDIRECT(B1)+C1

where B1 contains "A1" (w/o the quotes)

" wrote:

I have data in cell a1, I need a formula like d1 = b1+c1
I want b1 to point to a1 by reference only.

I just want to be able to enter a1 into b1 to get the value.
I do not want =a1 in cell b1.

[email protected]

References to cells in formulas

That works very well. Thank you very much!!!!

JMB wrote:
try

=INDIRECT(B1)+C1

where B1 contains "A1" (w/o the quotes)

" wrote:

I have data in cell a1, I need a formula like d1 = b1+c1
I want b1 to point to a1 by reference only.

I just want to be able to enter a1 into b1 to get the value.
I do not want =a1 in cell b1.

All times are GMT +1. The time now is 05:40 PM.