Array help

  • Thread starter Patty via OfficeKB.com
  • Start date
P

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

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)
 
R

Ron Coderre

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
 
Top