IF statement not returning correct answer

SOLVED
I'm having trouble with an IF formula.

My data is a number between -1 to -49 and 50 to 1. I'm trying to categorize this range into several categories.

-1 to -5 = "Backed Up"

-6 to -20 = "Yellow Zone"

-21 to +21 = "Green Zone"

+20 to +12 = "Hi Red Zone"

+11 to +4 = "Lo Red Zone"

+3 to +1 = "Goal Line"

I've tried this, but it does not return the correct answer:

=IF(E41>=-20,"Green Zone", IF(E41>=20,"Hi Red Zone", IF(E41>=12, "Lo Red Zone", "Goal Line")))

if e41 = -25

ANY Help would be greatly appreciated!!

Thank you!

Welcome to the forum.

The bands you have outlined are not distinct: would 17 be green or hi red???

I'd use a lookup for this, not nested IFs.

There are instructions at the top of the page explaining how to attach your sample workbook.

Do you see the logical contradiction here?

-21 to +21 = "Green Zone"

+20 to +12 = "Hi Red Zone

Values between +12 and +20 belong to BOTH groups.

Set them out logically on a sheet, read the yellow banner (top of page) and attach the file.

Yes, but not if you have overlaps:

-21 to +21 = "Green Zone"

+20 to +12 = "Hi Red Zone"

Just looked at your attachment, but all you've shared is a non-working formula.

Please do what Glenn asked in post #5 above and post again to a new post in this thread. We can't help until the anomaly in your suggested bands is resolved.

OK, well in that case, please mark the thread as solved. You'll never know now how to create a lookup table!

Next time, just answer our questions and we'll do our best to help, but don't ignore our questions, as that's a waste of our time. Also, remember that many of us here do not have Stateside knowledge of your American rules football!!!