harryhornet
New Member
- Joined
- Feb 28, 2019
- Messages
- 7
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?
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?