formulas containing constants

[fentonas1]

Hi, it's been a long time since I have worked with formulas and I am having
problem with a formula that is working with constants. My formula is:
=IF(OR(B2=$G2,B2=$G3,B2=$G4,B2=$G5),"Already set up","Not set up")
G2 through G5 should remain constant. What am I doing wrong?

 

[tompl]

Not exactly clear what you mean by constant, but I will guess that you need
=IF(OR(B2=$G$2,B2=$G$3,B2=$G$4,B2=$G$5),"Already set up","Not set up")
so that the row number does not change when you copy the formula.

Tom

 

[Gord Dibben]

Your $ signs have made column G constant but not rows.

You need to also make them constant.

=IF(OR(B2=$G$2,B2=$G$3,B2=$G$4,B2=$G$5),"Already set up","Not set up")


Gord Dibben MS Excel MVP

 

[tompl]

I don't understand why you answered this question an hour after I had already
answered it, with the same answer.

 

[Rick Rothstein]

The time stamps show the time difference is 21 minutes, not an hour. More
than likely, your message got delayed in one of the servers and did not get
posted as soon as you sent it. My guess is that Gord read into the thread
before your response hit the server his ISP uses. These kind of delays
happen all the time.

 

[Gord Dibben]

I copied your answer then posted it as my own so I could get brownie points.


Gord

 

[Rick Rothstein]

Uh-oh, you just told everybody the secret of how to become an Excel MVP.<g>

 

[Gord Dibben]

I thought you got to be MVP by adding a sig line like "Click the Yes button
so's I can be graded on my answer"


Gord Dibben MS Excel MVP