Automatically generating a number range

[Alyssa C.]

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!

 

[Nobody]

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

 

[Ron Coderre]

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