Hi all,
I am trying to use the below formula and it is giving me an formula error, can someone please help me correct it?
=IF(AND($B$1<=6,$B$2<=5),"Good",IF(AND($B$1>6,$B$1<9,$B$2>5,$B$2<=8),"Average",IF(AND($B$1>=9,$B$2>8,$B$2<6),"Low",IF(and(B1>=9,b2<6,"Low","")))))
Thanks,
Karthik