Hi Joe,
Look up Absolute and Relative references in HELP.

With the short example you gave this may be what you want, it will
fill across as you asked for, but you example does not show copying downward.

Use of Fill Handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joe" wrote in message ...
I have a question?
When you are making a cell with a formula the references are set. But when
you copy the cell each cell reference changes relative to the position the
new cell is. My question is, is it possible to have to cell references stay
the same in all cells when i copy and the other cell reference change
relative to the new cell. I am wondering so that i dont have to change the 2
cell referance in all the new cells cells.
I am sorry if this question is hard to understand b/c i am having a hard
time explaning so here is an example.

Here is cell G5: =IF(C15=G14,+E15,0)
If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
But I want H5 to equal: =IF(C15=H14,+E15,0)

Can someone please help.
Thanks,
~Joe