I think I need IF function!

[Ellasheba]

Hello. I thought I had been given the answer to my question, but looking back I didnt (my fault for not explaining) and now I need this information to work again. I have attached a sheet with an example of my data and then what I need it to do. I think its an IF function. Basically trying to identify emerging figures in a sheet. Hope the attached explains it.. Thanks in advance

 

[Luke M]

Hi Ellasheba.

Let's call the sum of A2:F2 x, and the SUM of G2:J2 y. You actually have 4 possible outcomes:

1. X = 0, Y > 0
2. X = 0, Y = 0
3. X > 0, Y > 0
4. X > 0, Y = 0

You've stated what you want as the output for #1 (Yes) and for #4 (No). What do you want to happen for other conditions?

=IF(SUM(A3:F3)=0,IF(SUM(G3:J3)>0,"Yes","Option 2"),IF(SUM(G3:J3)>0,"Option 3","No"))

 

[chirayu]

=IF(AND(SUM($A2:$F2)=0,SUM($G2:$J2)>0),"Yes",IF(AND(SUM($A2:$F2)>0,SUM($G2:$J2)=0),"No",NA()))

 

[Ellasheba]

Hi Luke and Chirayu. Both your solutions work so thank you both so much for that. Luke I hadnt even thought about the other 2 options, as the idea is to identify emerging and disappearing issues in particular, but I will think about that as it would be useful. Thanks again for your help guys, so much appreciated.