Prev: Locking all text, combo and check boxes
Next: CDbl and "Type mismatch"
From: fentonas1 on 25 Mar 2010 17:41
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
From: tompl on 25 Mar 2010 17:57
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
From: Gord Dibben on 25 Mar 2010 18:18
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
<fentonas1(a)discussions.microsoft.com> 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?

From: tompl on 25 Mar 2010 19:41
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
> <fentonas1(a)discussions.microsoft.com> 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?
>
> .
>
From: Rick Rothstein on 25 Mar 2010 20:04
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" <tompl(a)discussions.microsoft.com> wrote in message
news:388D1603-B9BC-4266-9080-BF58D5CE5FC7(a)microsoft.com...
> 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
>> <fentonas1(a)discussions.microsoft.com> 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?
>>
>> .
>>
 |  Next  |  Last
Pages: 1 2
Prev: Locking all text, combo and check boxes
Next: CDbl and "Type mismatch"