Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array help
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! -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
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) -- HTH Bob Phillips "Patty via OfficeKB.com" wrote in message ... 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! -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
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 "Patty via OfficeKB.com" wrote: 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! -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |