Let's try this again!
This is what I want to do.

I want a cell to put the following

If E2 (contains the invoice amount) is between $0 and $50 put "$0 -
$50.00" in the cell.
If E2 is between $50.01 - $100 put "$50 -$100"
If E2 is between $100.01 - $500 put "$100 - $500"
If E2 is between $500.01 - $1000.00 put $500 - $1000"
And if it's over $1000.01 then put "1000+"

How do I make this into a formula?
--
Thanks for your help!

Walter