Prev: Locking all text, combo and check boxes
Next: CDbl and "Type mismatch"
From: Gord Dibben on 26 Mar 2010 10:45
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 <tompl(a)discussions.microsoft.com>
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
>> <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 26 Mar 2010 11:22
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
news:rthpq59r687jkaun2ur5vtaavg7fkpnfrp(a)4ax.com...
> 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
> <tompl(a)discussions.microsoft.com>
> 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
>>> <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: Gord Dibben on 26 Mar 2010 17:02
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"
<rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote:

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

First  |  Prev  | 
Pages: 1 2
Prev: Locking all text, combo and check boxes
Next: CDbl and "Type mismatch"