View original (French)

IF function with multiple conditions using less than and greater than

Solved
Camcam -  
 Camcam -
Hello,

I'm having some issues with an Excel formula.

I would like:
- If AA2 is less than 1, then 1
- If AA2 is between 1 and 5 inclusive, then 2
- If AA2 is between 6 and 10 inclusive, then 3
- If AA2 is greater than 10, then 4

What is wrong with my formula?

=IF(AA2<1,1,IF(AND(AA2>=1,AA2<=5),2,IF(AND(AA2<=6,AA2<=10),3,IF(AA2>10,4))))

Excel seems to work fine for giving me 1 and 4, but it's the 2 and 3 that aren't working...

Thank you for your help!!

1 réponse

Réponse 1 / 1
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

You can simplify your formula already:
=IF(AA2<1,1,IF(AA2<=5,2,IF(AA2<=10,3,4)))

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
3
Camcam
 
Why make things complicated when they can be simple?
Thank you, it's perfect!
0