Nested if and formula

[karthik_kaliappan]

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

 

[Joe4]

You missed the parenthesis at the end of your last AND, and have an extra one at the end.
It should look like this:

=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",""))))