|
Automatically generating a number range
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! |
Automatically generating a number range
=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! |
Automatically generating a number range
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! |
| All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com