Nesting IF Statements

  • Thread starter Thread starter Gaz
  • Start date Start date
G

Gaz

How do I nest this together?


If A1 = 0 & B1 =0, "OK"

If A1 >0 & B1 = 0, "No B"

If A1 = 0 & B1 >0, "No A"

If A1 >0 & B1 >0, "OK"


cheers

Gaz
 
Try:
=if(and(a1=0,b1=0),"OK",if(and(a1>0,b1=0),"No B",if(and(a1=0,b1>0),"No
A",if(and(a1>0,b1>0),"OK","None of the above"))))

Regards,
Fred
 
Gaz said:
How do I nest this together?
If A1 = 0 & B1 =0, "OK"
If A1 >0 & B1 = 0, "No B"
If A1 = 0 & B1 >0, "No A"
If A1 >0 & B1 >0, "OK"
Click to expand...

=if(and(A1>0,B1=0), "No B",
if(and(A1=0,B1>0), "No A", "OK"))

If A1 and B1 may be negative, then:

=if(and(A1<>0,B1=0), "No B",
if(and(A1=0,B1<>0), "No A", "OK"))
 
How do I nest this together?


If A1 = 0 & B1 =0, "OK"

If A1 >0 & B1 = 0, "No B"

If A1 = 0 & B1 >0, "No A"

If A1 >0 & B1 >0, "OK"


cheers

Gaz
Click to expand...

And a little different approach, just for kicks:

=CHOOSE(1+BIN2DEC(--(A1>0) & --(B1>0)),"OK","No A","No B","OK")

--ron
 
How do I nest this together?


If A1 = 0 & B1 =0, "OK"

If A1 >0 & B1 = 0, "No B"

If A1 = 0 & B1 >0, "No A"

If A1 >0 & B1 >0, "OK"


cheers

Gaz
Click to expand...

And still another approach:

=INDEX({"OK","No A","No B","OK"},1+(A1>0)*2+(B1>0))

--ron
 
Back
Top