Help with a formula

[richard1234567891011]

Hello guys I have an Issue with a formula.

=IF(COUNTIF($G130:L130;"YES");0;-12*$F22)

In this formula I have to add a second condition. IF(O120>F19)

Practically I want both conditions in the formula.

Thank you.

 

[JoeMo]

Maybe:

=IF(AND(COUNTIF($G130:L130;"YES");O120>F19);0;-12*$F22)

 

[richard1234567891011]

Thank you but I solved the problem. With And it dosn't work, It works with OR

 

[richard1234567891011]

=SE(O(CONTA.SE($G130:G130;"YES");(H120>$F19));(0);(-12*$F22))

In this way. (in Italian)

PS the cells are different

 

[Joe4]

Thank you but I solved the problem. With And it dosn't work, It works with OR

Since you didn't explain exactly what you were after in your original question, it was not possible for us to tell exactly what you wanted.
You mentioned that you wanted to add another Condition, but didn't mention if you wanted an AND or an OR type relationship between your conditions.

With AND, all conditions must be met.
With OR, only one condition must be met.

 

[richard1234567891011]

Ok, So I explained bad, because I needed one condition.