IF function with multiple conditions

[izabela92]

Hello,

I am trying to write an IF function with two conditions, SUM(C2+D2+E2+G2)>0 and SUM(B2+F2+H2+I2+J2+K2+L2)=0. So only if certain fields are filled in and others are 0 I want it to return a value.

I have this so far but it does not seem to work properly =IF(AND(SUM(C2+D2+E2+G2)>0), (SUM(B2+F2+H2+I2+J2+K2+L2)=0), "BAD") . Can anyone help with this? Not sure what I am doing wrong.

Thanks!

 

[Marcílio_Lobão]

izabela92, Good afternoon.

Try to use:

=IF(AND(SUM(C2+D2+E2+G2)>0, SUM(B2+F2+H2+I2+J2+K2+L2)=0), "BAD", "Other")

I think it's just a question with the parentheses in the formula.

I hope it helps.

 

[Scott Huish]

By the way you can include the ranges in the SUM function instead of listing all the individual cells:

=IF(AND(SUM(C2:E2,G2)>0, SUM(B2,F2,H2:L2)=0), "BAD", "Other")

 

[Marcílio_Lobão]

Scott Huish, Good afternoon.

Solution much more elegant than my suggestion.

Have a nice day.

Greetings from Brazil.

 

[izabela92]

Thank you so much! that was exactly what I needed.