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

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

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