View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nison Maksumov Nison Maksumov is offline
external usenet poster
 
Posts: 1
Default FUNCTION Problem, Please advise

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?