Function containing $
 

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)".

Function containing $
 

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

On Jan 23, 3:32*pm, Dave wrote:
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)".

Function containing $
 

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

"Dave" wrote:

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)".