Automatically generating a number range

G

Guest

Iâ€™ve created a pretty extensive excel workbook with all sorts of
automatically generated charts and metrics. Iâ€™m 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 donâ€™t
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!

=IF(A1<=1000,"\$0 - \$500",IF(A1<=2000,"\$1000 -\$2000","\$10000"))

Try something like this example:

Put this table in A1:B5
0 <\$1001
1001 \$1001-\$2000
2001 \$2001-\$3000
3001 \$3001-\$4000
4001 >=4001

A10: (enter a number)

This formula displays the appropriate range that the A10 values fits into:
B10: =VLOOKUP(A10,\$A\$1:\$B\$5,2,1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP