if formula based on ranges

[snash]

Hi there, I want to input a formula that looks at column A and assigns a group. So if(A2>,"0-5",if(A2<=0,"6-10",if(A2<=5,"11-15",IF(A2<=0,"16-30",if(A2>50,">50"))))) How can I write this correctly?

Thanks!

 

[Joe4]

You have some missing details and errors in that formula to the extent that I cannot really understand exactly what you want to happen.
Can post your conditions, in plain English, of what you want to happen?

 

[snash]

Thanks Joe, basically I want a formula to show that if a number lands within a particular range, then I want the output to show the actual range??

 

[Joe4]

But what are your ranges? Your formulas have a bunch of errors in them, so I really cannot tell:

In looking at all your formulas, you have:
if(A2>,"0-5" you are missing a number after your greater than sign
if(A2<=0,"6-10" I fail to see how number less than zero would fall between 6 and 10
if(A2<=5,"11-15" I fail to see how number less than 5 would fall between 11 and 15
IF(A2<=0,"16-30" why are you checking for less than zero again (you already did that earlier)
if(A2>50,">50" ​this is the only one which seems to make any sense to me

 

[snash]

Hi, I know have it wrong - sorry. That's why I need help. I have a list of numbers in column A.
In Column B, I want to return a range, based on the number in Column A. The ranges are: 0-5, 6-10, 11-15, 16-30, 31-50, >50. So if A5 had a 28, then B5 would return the range "16-30". Make sense?

 

[Joe4]

Yes, that makes sense. Based on your original formula, I couldn't tell if you had some sort of special sequence or something.
Try this:

=IF(A2>50,">50",IF(A2>=31,"31-50",IF(A2>=16,"16-30",IF(A2>=11,"11-15",IF(A2>=6,"6-10",IF(A2>0,"0-5","NOT FOUND"))))))

The secret is to either start from the highest and work to the lowest, or vice versa.

 

[snash]

That's exactly it. Thanks and apologies for the confusion.

 

[Joe4]

No problem!

It is always a good idea if you have a formula (or VBA code) that is not working properly to explain how it should work (in addition to posting the formula).
Otherwise, if there is some flaw in the logic of your formula, the answer we come up for you may also contain that same flaw and be incorrect.