Blank cells in data

[harryhornet]

Hi All
I am using a If and statement to work out if performance has improved, declined or remained the same. I have used an if and statement as for some the data needs to be higher to be better and for others it needs to be lower to be better. I have included the formula that i am using
=IF((AND(D2="Lowest",F2<E2)),"Improve",IF((AND(D2="Lowest",F2>E2)),"Declined",IF((AND(D2="Lowest",F2=E2)),"No Change",IF((AND(D2="Highest",F2<E2)),"Declined",IF((AND(D2="Highest",F2>E2)),"Improve",IF((AND(D2="Highest",F2=E2)),"No Change",IF(F2=”<>”,"No Data",IF(E2=”<>”,”No Data”,”Else”))))))))

however there are some cells with no data. i tried adding in this
IF(F2=”<>”,"No Data",IF(E2=”<>”,”No Data”,
but it didn't work

any suggestions?

 

[VBE313]

=IF(OR(F2="",E2=""),"No Data","")

 

[harryhornet]

thank you

 

[jasonb75]

You can make the whole thing a lot shorter and easier to manage by reorganising it

=IF(COUNT(E2:F2)<2,"No Data",IF(E2=F2,"No Change",IF(OR(AND(F2>E2,D2="Lowest"),AND(F2<E2,D2="Highest")),"Declined","Improve")))