You must anchor the references using the $ character, so
your formula becomes:

=IF(C$67=G69;M4;0)

-----Original Message-----
I have "IF" formula...

=IF(C67=G69;M4;0)

c69 - number.

m4 result if c67=g69

0 if not.

When I'm copying that formula (dragging with mouse..
autopaste) I'm getting
autochanging in formula

=IF(C68=G70;M5;0) ,,

=IF(C69=G71;M6;0)

a problem is I dont wanna that G69 will change, so it
will be in all others
functions.

How can I do it?





.