formulas containing constants

F

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

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
 
G

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
 
T

tompl

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

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.
 
G

Gord Dibben

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


Gord
 
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
 

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

Top