FUNCTION Problem, Please advise

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?
 
R

Ryan Poth

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FUNCTION problem, Please Advise 3
Please help with simple function 1
vba Function code 1
Alternative to Application.Caller in array functions to avoid wrong results? 11
Creating Custom Function - A Little Help Please! 7
pasting formulas 2
Problem with user functions in Add-ins for multiple persons 1
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10

Top