anchoring a cell reference in formula copied or dragged over a ran

[nev4ever]

= 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

 

[Mike H]

Hi,

Like this

= IF(Condition,$G1$4*b,"")

Note you can 'anchor' rows or columns and like above both rows and columns.

Mike

 

[nev4ever]

Thanks heaps Mike,, I tried everything except $

Hi,

Like this

= IF(Condition,$G1$4*b,"")

Note you can 'anchor' rows or columns and like above both rows and columns.

Mike