If and statement for multiple criteria

Hi All

Need a formula for the following statement please:

If C75="YES" and K14>0 then value = 60
Else
If C75 = "YES" and K14>0 and L14>0 then value = 120
Else
If C75 = "YES" and K14>0 and L14>0 and M14>0 then value = 150
Else value = 0

Thank you in advance for your help.

Try

=IF(AND(C75="yes",K14>0),60,IF(AND(C75="yes",K14>0,L14>0),120,IF(AND(C75="yes",K14>0,L14>0,M14>0),150,0)))

Let me give a detailed explanation.

I have three columns K14,L14 AND M14 which can be populated with either 0 or 1 or 2.
Lets pretend C75 is always YES.

If any one of the columns > 0 then 60

If any two of the columns > 0 then 120

If all 3 columns > 0 the 150

Hi John

Thanks for input. Strange enough, I tried that and it always returns the value of 60.

I'm lost

try

=IF(AND(C75="yes",COUNT(K14:M14)=1),60,IF(AND(C75="yes",COUNT(K14:M14)=2),120,IF(AND(C75="yes",COUNT(K14:M14)=3),150,0)))

Also:

=IF(C75="YES",MIN(COUNT(K14:M14)*60,150),0)

Hi Guys

Both work as long as The columns are blank or 1 or 2.
However, if 0 is inserted then it doesn't work

Not to worry.

I have used data validation in columns which forces 1 or 2...Problem solved.
Thank you John & Beamernsw

Awesome thanks
Beamernsw