Combining two IF statements into one cell

[jsflbot]

Hello! I'm trying to combine two IF statements but need help on how to do this...

Argument #1: =IF(AND(ISNUMBER(B5),ISBLANK(C5)),"New Fallout","No Change")
Argument #2: =IF(AND(ISBLANK(B5),ISNUMBER(C5)),"New Sale","New Fallout")

I need these two arguments to be combined into one cell, any help is appreciated, thanks!

 

[Joe4]

I think we are approaching this from the wrong angle. Please explain (in English, not with formulas) exactly what these new rules are.
Specifically, what could be in cells F11 and G11, and what each situation should return.
Once we have clarified the exact rules of logic, creating the formulas becomes much easier.

 

[jsflbot]

I figured it out Joe, I just needed to sit down and break it down on a piece of paper.

This is the final formula: =IF(AND(F11>0, G11=0),"New Fallout", IF(AND(F11=0, G11>0),"New Sale","No Change"))

 

[Joe4]

Glad to hear it!

Yes, sometimes it is best to take a step back and start from the beginning.