Simple Nested IF - Won't Work

[FanofExcel18]

I can't seem to get this to work.

<=5% = 1
>5% - 10% = 2
11%=3
12%>4

=IF(AND(D3<0.05),1,IF(AND(D3>0.05),2,IF(AND(D>=0.11),3,IF(AND(D3>0.12),4))))

=IF(AND(D3<0.05),1,IF(AND(D3>=0.05),2,IF(AND(D<=0.10),2,IF(AND(D3=0.11),3,IF(AND(D3>=0.12),4)))))

 

[Joe4]

You are welcome!
Glad we could help.

As you can see, there are many different ways to approach and solve this.