Excel IF Function problem in Excel....

[Matthew Smith]

Can anyone please help?
I have Cell I4 which displays a value between 0 and 30.
I want J4 to display the following text
If I4<5 display Below
If I4>5 display Expected
If I4>10 display Above

Can anyone help????
I have tried this but it doesn't work....
=IF(I4>10,"Above","Expected", IF(I4<5,"Below","Expected))
Many thanks
Matthew

 

[TGB]

Here's your formula
=IF(I4>10,"Above",IF(I4>4,"Expected", IF(I4<5,"Below")))
I have set it so that exactly 5 returns "Expected"
Good luck

 

[Matthew Smith]

Thank you