Cell needs to be blank if False

[Odlaw72]

Hi I have a nested formula but I am not able to get a blank cell if none of the parameters are met?

I have attached a picture and the formula is below.

=IF(AND(C2<=4,D2<=4),"NUISANCE",IF(AND(C2>=5,D2<=4),"EXPLOITABLE",IF(AND(C2<=4,D2>=5),"DEVELOPMENT",IF(AND(C2>=5,D2>=5),"CORE",""))))


Thank you in advance.

 

[Odlaw72]

Picture located here:

 

[mrshl9898]

=if(and(c2="",d2=""),"",if(and(c2<=4,d2<=4),"nuisance",if(and(c2>=5,d2<=4),"exploitable",if(and(c2<=4,d2>=5),"development",if(and(c2>=5,d2>=5),"core","")))))

 

[Odlaw72]

Thank you so much worked a treat

 

[Michael M]

AN Or statement at the beginning will fix that AND you don't nned the last IF statement

=IF(OR(C2="",D2=""),"",IF(AND(C2<=4,D2<=4),"NUISANCE",IF(AND(C2>=5,D2<=4),"EXPLOITABLE",IF(AND(C2<=4,D2>=5),"DEVELOPMENT","CORE"))))