Try the below

=IF(MEDIAN(9,T4,13)=T4,"Level 4","")

If this post helps click Yes
---------------
Jacob Skaria


"Shadowdw" wrote:

This may sound daft but i'm baffled! I have an IF formula shown below:

=IF(T4= ,"Level 4","")

in the large gap above I would like to place the numbers 9 through to 13. I
wish to add these because I want the text "Level 4" to appear only when the
numbers 9 through 13 are in a box. But when I try:

=IF(T4=9:13,"Level 4","")

it trys to use cells 9:13 not numbers! Help please!