| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) | |||
| pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
Linear Mode
