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

N

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
 
M

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
 
N

nev4ever

Thanks heaps Mike,, I tried everything except $

Mike H said:
Hi,

Like this

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

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

Mike
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Building a Dynamic Sheet number in a formula 2
Build a sheet name in an Excel formula 2
Building a Sheet Name in a Formula 0
Cell reference value to remain constant in a sort using Paste Link 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Value used in a Paste Link to remain constant during a sort 1
Building a reference by concatenating components 4
Referencing rows to columns 3

Top