| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formula
I have the following formula in cell A1 =IF(B1="","",ItemList!B2) When
dragging/copying the formula to down to A2, A3 etc How do I keep the ItemList cell reference = to B2? -- Regards Michael Koerner |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying formula
By absulute reference:
A1 =IF(B1="","",ItemList!$B$2) regards, Stefi €˛Michael Koerner€¯ ezt Ć*rta: I have the following formula in cell A1 =IF(B1="","",ItemList!B2) When dragging/copying the formula to down to A2, A3 etc How do I keep the ItemList cell reference = to B2? -- Regards Michael Koerner |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying formula
Thanks, I was missing the 2nd $
-- Regards Michael Koerner "Stefi" wrote in message ... By absulute reference: A1 =IF(B1="","",ItemList!$B$2) regards, Stefi "Michael Koerner" ezt ķrta: I have the following formula in cell A1 =IF(B1="","",ItemList!B2) When dragging/copying the formula to down to A2, A3 etc How do I keep the ItemList cell reference = to B2? -- Regards Michael Koerner |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying formula
Very very easy: lock the cell reference in the formula. Highlight "B2" in your formula and press F4. It will become: =IF(B1="","",ItemList!$B$2) The $ signs indicate that both the row and column references ar locked. (you could also lock rows only: B$2 or columns only: $B2 by pressin F4 several times or by directly adding the $ signs in the formula. -- lux77 ----------------------------------------------------------------------- lux770's Profile: http://www.excelforum.com/member.php...fo&userid=2497 View this thread: http://www.excelforum.com/showthread.php?threadid=39055 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying formula
Much appreciated, thank you very much.
-- Regards Michael Koerner "lux770" wrote in message ... Very very easy: lock the cell reference in the formula. Highlight "B2" in your formula and press F4. It will become: =IF(B1="","",ItemList!$B$2) The $ signs indicate that both the row and column references are locked. (you could also lock rows only: B$2 or columns only: $B2 by pressing F4 several times or by directly adding the $ signs in the formula.) -- lux770 ------------------------------------------------------------------------ lux770's Profile: http://www.excelforum.com/member.php...o&userid=24970 View this thread: http://www.excelforum.com/showthread...hreadid=390552 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying formula | Excel Worksheet Functions | |||
| Copying formula | Excel Discussion (Misc queries) | |||
| Copying Formula | Excel Programming | |||
Linear Mode
