Multiple conditions question

[andonny]

Hi,
My problems are never ending.
I need to place the number 1 into cell H1 if any of the numbers below are in range A1:G1 and the same for the next row (A2:G2 --> H2) and so on until the last used row.

The numbers are 45,213,300,20,60,81,52

Thank you very much for your help
Andonny

 

[Ian Mac]

On 2002-09-25 05:17, andonny wrote:
Hi,
My problems are never ending.
I need to place the number 1 into cell H1 if any of the numbers below are in range A1:G1 and the same for the next row (A2:G2 --> H2) and so on until the last used row.

The numbers are 45,213,300,20,60,81,52

Thank you very much for your help
Andonny

Use:

=IF(SUMPRODUCT((A1:G1={45;213;300;20;60;81;52})*1),1,0)

 

[Aladin Akyurek]

On 2002-09-25 05:31, Ian Mac wrote:
Use:

=IF(SUMPRODUCT((A1:G1={45;213;300;20;60;81;52})*1),1,0)

Ian,

We can drop IF from it...

=SUMPRODUCT((A1:G1={45;213;300;20;60;81;52})+0)

Aladin