FUNCTION problem, Please Advise

[Nison Maksumov]

I have "IF" formula...

=IF(C67=G69;M4;0)

c69 - number.

m4 result if c67=c69

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?

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets

 

[Dave Peterson]

You have a couple replies at your other post.

I have "IF" formula...

=IF(C67=G69;M4;0)

c69 - number.

m4 result if c67=c69

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?

 

[Brad]

I understand your problem. You need to anchor your cell reference. To do
that you use dollar signs "$". If you want your formula to always reference
a particular fixed location, like G69, you can do it as follows:

=IF(C67=$G$69;M4;0)

any cells that need to remain linked to a fixed location need have a dollar
sign before the Vertical coordinate (G) as well as the horizontal coordinate
(69)