| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anchoring a cell reference in formula copied or dragged over a ran
= IF(Condition,G14*b,"") where b is a constant named on another sheet,
Starting with this formula,, How does one ensure that the cell reference "G14" remains constant when copying the whole down a column or along a row? taa,, NevW |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
anchoring a cell reference in formula copied or dragged over a ran
Hi,
Like this = IF(Condition,$G1$4*b,"") Note you can 'anchor' rows or columns and like above both rows and columns. Mike "nev4ever" wrote: = IF(Condition,G14*b,"") where b is a constant named on another sheet, Starting with this formula,, How does one ensure that the cell reference "G14" remains constant when copying the whole down a column or along a row? taa,, NevW |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
anchoring a cell reference in formula copied or dragged over a
Thanks heaps Mike,, I tried everything except $
"Mike H" wrote: Hi, Like this = IF(Condition,$G1$4*b,"") Note you can 'anchor' rows or columns and like above both rows and columns. Mike "nev4ever" wrote: = IF(Condition,G14*b,"") where b is a constant named on another sheet, Starting with this formula,, How does one ensure that the cell reference "G14" remains constant when copying the whole down a column or along a row? taa,, NevW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Anchoring Cell Contents | Excel Discussion (Misc queries) | |||
| 'anchoring' or 'grounding' part of a formula | Excel Discussion (Misc queries) | |||
| Cell reference update when copied and pasted | Excel Worksheet Functions | |||
| Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Linear Mode
