References to cells in formulas

[jasonb]

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.

 

[Guest]

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

try

=INDIRECT(B1)+C1

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

 

[Guest]

try

=INDIRECT(B1)+C1

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

 

[jasonb]

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

try

=INDIRECT(B1)+C1

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