Formula Help

[Jade]

I'm trying to figure out this formula. The thing that
confuses me is that the cell G1 is blank. Is it actually
referencing G1? What are the $ signs around it? $G$1


=IF($G8=$G$1,($H8*8)*J$3,IF(AND($G8>J$1,$G8<K$1),(($E8*8)
*J$2)+(($H8*8)*J$2),IF($G8>K$1,($E8*8)*J$3,($H8*8)*J$3)))

Thanks a lot for the help in advance.

Jade

 

[Juan Pablo González]

I'm trying to figure out this formula. The thing that
confuses me is that the cell G1 is blank. Is it actually
referencing G1? What are the $ signs around it? $G$1


=IF($G8=$G$1,($H8*8)*J$3,IF(AND($G8>J$1,$G8<K$1),(($E8*8)
*J$2)+(($H8*8)*J$2),IF($G8>K$1,($E8*8)*J$3,($H8*8)*J$3)))

Thanks a lot for the help in advance.

Jade

It's an absolute reference to G1. Look here:

http://www.cpearson.com/excel/relative.htm