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!

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


"Alyssa C." wrote:

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!

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


"Alyssa C." wrote:

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!