Excel what does this mean?

[marine1]

=IF(ISERR(I8/$I$10),0,(I8/$I$10))

What do Dollar signs mean, I am no expert in Excel

Thanks

 

[dj_jyno]

Absolute referencing. It keeps the cell address with the dollar sign in front constant, even if you copy it to other cells. In other words, if you put that formula in A13 and copy it to A14, the bit after I8/ will remain I10, it won't move on to I11.

 

[marine1]

Ahhh thanks man.

 

[MickeyD]

Extrapolating above...

a $ sign in front of the column indicator will keep that column constant.
a $ sign in front of the row indicator will keep that row constant.
a $ sign in front of the column and row indicator will keep that cell constant.

 

[InvisibleJim]

Excel Cell References

It's to do with absolute and relative cell references. I wrote you an explanation but this one's better

http://www.dummies.com/how-to/content/understanding-cell-references-in-excel.html

 

[zizo911]

absolute referencing