Excel HELP! (copy and paste)

[Javery]

I'm trying to copy and paste a row of cells with formulas without Excel adjusting for the difference in cells. I think throwing a "$" in there somewhere will prevent this but I can't get it to work.

For example:

ROW 1 + ROW 2 = ROW 3 (row 3 contains the formula "=A1+A2")

Now I want to have ROW 1 + ROW 6 = ROW 7 but when I copy and paste ROW 3 into ROW 7 it gives me ROW 5 + ROW 6 ("=A5+A6" instead of "=A1+A6" where A1 is 'fixed').

Any help would be great!

Thanks!

[mykevermin]

$Column$Row

[Javery]

$Column$Row

It's not working... In cell B6 I have (without quotes) "=IF($B3>B5,1,0)" and when I copy it to cell B9 I get "=IF($B6>B8,1,0)" instead of "=IF($B3>B8,1,0)"

I'm going crazy.

Edit: Shit, I might be missing a "$" .... hang on...

[mykevermin]

$b$6

[Javery]

That did it. Thanks!