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.
Bookmarks