Thread: anchoring a cell reference in formula copied or dragged over a ran
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nev4ever nev4ever is offline
external usenet poster
  
Posts: 2
Default 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
Reply With QuoteReply With Quote