FUNCTION Problem, Please advise

  • Thread starter Thread starter Nison Maksumov
  • Start date Start date
N

Nison Maksumov

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?
 
You must anchor the references using the $ character, so
your formula becomes:

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