Function containing $

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

What is the rwason for using the $ sign. I used
"=IF(Sat!$H$22=0,"",Sat!$H$22)" but i get the same result using
"=IF(Sat!H22=0,"",Sat!H22)".
 
The $ symbol in front of the row (or column) identifier means that the
row (or column) will not change when the formula is copied down (or
across) - it is thus considered to be "anchored" to the cell. Check
out what happens to the cell references in your two formulae if you
copy them across and down your sheet.

Check out Excel Help on Absolute References for more.

Hope this helps.

Pete
 
Hi,

The $ sign fixes the reference such that if you drag the formula dow or
across it doesn't change.

if you drag the formula =a1 down it becomes =A2 but if you have =$A$1 and
rag it it doesnt change

There are 4 states of reference

Relative =A1
Row absolute = A$1
Column absolute =$A1
Absolute =$A$1

Mike
 
Back
Top