Given your list of values is short, here is yet another way...

=IF(OR(T4={9,10,11,12,13}),"Level 4","")

--
Rick (MVP - Excel)


"Shadowdw" wrote in message
...
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!