=ifand$b$18

  1. K

    Nested if and formula

    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

Some videos you may like

This Week's Hot Topics

Top