# Solved: Nested IF Function Help Excel - Please :)

Discussion in 'Business Applications' started by Smileyriley81, Jan 29, 2013.

Not open for further replies.

Joined:
Jan 29, 2013
Messages:
2
Dear All,

I have written a nested IF statement in Excel 2010 that is not working quite how I'd like it to. I am wondering if anyoone can help?

SEV and OCC are whole integers between 1 and 10.

In the CLASS column: "CC" should return when SEV>= 8;
"SC" should return when 7>=SEV>=5 AND 10>=OCC>=4;
anything else should return nothing

I have managed to create the return situations "CC" and "SC" in rows 2 & 3 (in the picture above), with the following formula:

A2:
=IF(B2>=8,"CC",(IF(AND(7>=B2>=5,10>=C2>=4),"SC",(IF(OR(B2<5,C2<4),"")))))

The bold blue part of the formula was meant to cover the return situation of rows 4, 5 and 6. But instead of returning nothing, it's returning "SC". Can anyone suggest the changes I need to make?

2. ### etafModerator

Joined:
Oct 2, 2003
Messages:
65,252
First Name:
Wayne
This should work
=IF(B2>=8,"CC",IF(AND(B2<=7,B2>=5,C2<=10,C2>=4),"SC",""))

#### Attached Files:

• ###### nested_if.xlsx
File size:
10.2 KB
Views:
26

Joined:
Jan 29, 2013
Messages:
2
ETAF!

That was super super quick. And thank you, it works perfectly ))

As Seen On