Numbers in a formula!

S

Shadowdw

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!
 
J

Jacob Skaria

Try the below

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

If this post helps click Yes
 
R

Rick Rothstein

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

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