Help with Formula

[George Gee]

Hi all

How do I express this as a formula in Excel:
In P2: If the value in C12 appears in the range C9:H9 then 1 otherwise 0

Hope this makes sense

TIA

George

[JE McGimpsey]

One way:

=--(COUNTIF(C9:H9,C12)>0)

In article <[email protected]>,
"George Gee" <[email protected]> wrote:

> Hi all
>
> How do I express this as a formula in Excel:
> In P2: If the value in C12 appears in the range C9:H9 then 1 otherwise 0
>
> Hope this makes sense
>
> TIA
>
> George

[George Gee]

Many thanks, such a speedy reply.
Have a drink on me!

George

*JE McGimpsey* has posted this message:

> One way:
>
> =--(COUNTIF(C9:H9,C12)>0)
>
> In article <[email protected]>,
> "George Gee" <[email protected]> wrote:
>
>> Hi all
>>
>> How do I express this as a formula in Excel:
>> In P2: If the value in C12 appears in the range C9:H9 then 1
>> otherwise 0
>>
>> Hope this makes sense
>>
>> TIA
>>
>> George

[pkghosh]

Please visit and let me know, if you have have the answer!
PK Ghosh

[sgrech]

can somebody please explain the -- part of this formula?

thanks
simon