LinkBack URL
About LinkBacks
Bloemendaal 
I am looking to create a formula that returns a certain number range label (like "<1" or "1-3" or "3-5") for each number in a column. Please see the attached.
I am looking to create a formula that returns a certain number range label (like "<1" or "1-3" or "3-5") for each number in a column. Please see the attached.
Check it out
Formula:
=IF(A2<1,"<1",IF(AND(A2>=1,A2<3),"1-3",IF(AND(A2>=3,A2<5),"3-5",IF(AND(A2>=5,A2<7),"5-7",IF(AND(A2>=7,A2<10),"7-10",">10")))))
Thanks so much!
try:Formula:=CHOOSE(MATCH(A2,{0,2,3,5,8,10}),"<1","1-3","3-5","5-7","7-10",">10")
If problem is resolved Add Reputation star to person(s) who helped you and mark thread as Solved. Thank you
edit:
Thanks for rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks