multicondition if

[jade]

Hi !

How could I do this:

I have numbers in cells a1,b1 and c1. If 2 of those
numbers are greater than 10, I want 12 in d1. In all other
cases d1 is 0. Thanx !

 

[Bob Phillips]

In D1

=IF(OR(AND(A1>10,B1>10),AND(B1>10,C1>10),AND(A1>10,C1>10)),12,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

or even

=IF(COUNTIF(A1:C1,">10")>1,12,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanx Bob !

But if all three numbers are greater than 10, the result
in D1 should be 0.

Greetings

J

 

[Max]

But if all three numbers are greater than 10, the result
in D1 should be 0.

Try this slight mod of Bob's suggestion:
=IF(COUNTIF(A1:C1,">10")=2,12,0)

 

[Guest]

Think that should be >=IF(COUNTIF(A1:C1,">10")>=2,12,0)

 

[Max]

Think that should be >=IF(COUNTIF(A1:C1,">10")>=2,12,0)

This won't return 0 (it returns 12) if all 3 numbers are greater than 10,
which was the OP's specs in response to Bob's earlier suggestion, re:

 

[Jade]

Great !
Thanx Max !

Jade

-----Original Message-----


Try this slight mod of Bob's suggestion:
=IF(COUNTIF(A1:C1,">10")=2,12,0)

 

[Max]

Great !
Thanx Max !

You're welcome, Jade !
Thanks for the feedback