Ive created a pretty extensive excel workbook with all sorts of
automatically generated charts and metrics. Im trying to find out how I can
enter a dollar amount in one cell and have it automatically generate a dollar
range in another cell. Example:

Cell A1 Cell B1
I type in €œ$1,055.67€� €œ$1,000 - $2,000€� is automatically generated
I type in €œ$0.00€� €œ$0 - $500€� is automatically generated
I type in €œ$12,880.50€� €œ $10,000€� is automatically generated

I know how to create the dropdown list of ranges for column B, I just dont
know how to get it to fill in without having to select it myself.

I've also tried the whole If/Then function, but it isn't working. Here's
the function I tried:
=(IF(N5<1001,"<$1001"))*OR(IF(1001<=N5<2001,"$1001-$2000"))*OR(IF(2001<=N5<3001,"$2001-$3000"))*OR(IF(3001<=N5<4001,"$3001-$4000"))


Any thoughts? Thanks!