Array help

[Patty via OfficeKB.com]

I've used arrays only once before and need some help please!

I want to create a formula that does the following:
if A1 is between 0 and 0.5 then "T1," if A1 is between .51 and 1.0 then "T2"..
..I want to have 4 arguments in total (until T4).

Thank you!

 

[Bob Phillips]

It is not an array formula, jus

=IF(A1>=0,IF(A1<=0.5,"T1",IF(A1<=1,"T2",IF(A1<=1.5,"T3","T4"))),0)

 

[Guest]

Try one of these:

="T"&(FLOOR((A1-10^-5)/0.5,1)+1)

or

="T"&INT((A1-10^-5)/0.5)+1

Does that help?

••••••••••••••
Regards,
Ron