Evaluate input and return three possible outcomes

**sstyre** · 11-09-2012, 02:35 PM

I'm having some serious brain farts today in trying to get this to work completely. What I need to do is:

If A1 < 30, "0-30"
If A1 > 30 but < 60, "31-60"
If A1 > 60 "61+"

What I've got is: =IF(A1<31, "0-30", (IF(AND(A1>30, I2<60),"31-60"),IF(A1>60, "61+")))
What I keep getting is #VALUE!

I know it's something simple...but my brain doesn't want to work right it seems, haha.

**Ace_XL** · 11-09-2012, 02:37 PM

Try..

=IF(A1<=30,"0-30",IF(A1<=60,"31-60","61+"))
or
=LOOKUP(A1,{0,31,61},{"0-30","31-60","61+"})

**jeffreybrown** · 11-09-2012, 02:38 PM

How about

=LOOKUP(A1,{0,30,60},{"0-30","31-60","61+"})

**sstyre** · 11-09-2012, 02:40 PM

Originally Posted by Ace_XL

Try..

=IF(A1<=30,"0-30",IF(A1<=60,"31-60","61+"))

Bingo! We have a winner, thanks!

**djapigo** · 11-09-2012, 02:42 PM

Try this formula...

=IF(A1<31, "0-30", (IF(AND(A1>30,A2<60),"31-60",IF(A1>60, "61+"))))

You had the parentheses on the wrong place...

You can also create a VLOOKUP table for this... let me know if this is an option for you or if you want to see how it's done...

**jeffreybrown** · 11-09-2012, 02:50 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save