Formula Help

  • Thread starter Thread starter Jade
  • Start date Start date
J

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
 
Jade said:
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
Click to expand...

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

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