Nested if and formula

karthik_kaliappan

Board Regular
Joined
Jun 8, 2007
Messages
76
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

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,456
Office Version
  1. 365
Platform
  1. Windows
You missed the parenthesis at the end of your last AND, and have an extra one at the end.
It should look like this:
Code:
=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",""))))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,019
Messages
5,526,290
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top