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

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



"fentonas1" wrote:

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

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


On Thu, 25 Mar 2010 14:41:02 -0700, fentonas1
wrote:

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?

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

"Gord Dibben" wrote:

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


On Thu, 25 Mar 2010 14:41:02 -0700, fentonas1
wrote:

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?

.

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.

--
Rick (MVP - Excel)



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

"Gord Dibben" wrote:

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


On Thu, 25 Mar 2010 14:41:02 -0700, fentonas1
wrote:

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?

.

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


Gord

On Thu, 25 Mar 2010 16:41:01 -0700, tompl
wrote:

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

"Gord Dibben" wrote:

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


On Thu, 25 Mar 2010 14:41:02 -0700, fentonas1
wrote:

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?

.

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

--
Rick (MVP - Excel)



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I copied your answer then posted it as my own so I could get brownie
points.


Gord

On Thu, 25 Mar 2010 16:41:01 -0700, tompl

wrote:

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

"Gord Dibben" wrote:

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


On Thu, 25 Mar 2010 14:41:02 -0700, fentonas1
wrote:

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?

.

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


On Fri, 26 Mar 2010 11:22:22 -0400, "Rick Rothstein"
wrote:

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