I wanted to know if someone could help me with a formula as I've been struggling with it. I am so horrible at formulas, but I know this one should be so easy!!

Here are the details:

REFERENCE FIELD = Total Hours
FORMULA = I'm attempting to create a custom field (called HOUR BUCKET) that is a TEXT FORMULA field that will take the "TOTAL HOURS" and break it out into buckets.

For example - in English this is how the formula would be:

1.) If "Total Hours" is less than or equal to 40 hours = the HOUR BUCKET should populate with "40 hours or less"
-or-
2.) if "Total Hours" is more than 40 AND less than 100 hours = the HOUR BUCKET should populate with "41 - 99 hours"
- or -
3.) if "Total Hours" is more than 99 AND less than 500 hours = the HOUR BUCKET should populate with "100 - 499 hours"
- or -
4.) If "Total Hours" is greater than 499 = the HOUR BUCKET should populate with "500+ hours"

I'm having trouble with all the "ANDS" and "ORs" and "IFs" and where to put the appropriate quotes and parenthesis.

Please please help me! Thank you so much!!!