"Probabilities" formula

**lu007** · 09-08-2009, 10:20 AM

Hello,
Could you please help me with the following formula that I'm struggle with.

If a number in A4 is the same as in A1:A3 to return on B1 "+" , if it's not the same to return "-".

Thank you in advance !

**zbor** · 09-08-2009, 10:53 AM

like this?

=IF(ISNA(MATCH(A4;A1:A3;0));"-";"+")

**Palmetto** · 09-08-2009, 11:48 AM

Or this: =IF(COUNTIF(A1:A3,A4)>0,"+","-")

**DonkeyOte** · 09-08-2009, 12:20 PM

though technically no need for the >0 test

**Palmetto** · 09-08-2009, 12:24 PM

though technically no need for the >0 test

True. (force of habit

)

Re: "Probabilities" formula