These are the dollar ranges I want to cover on the new column I want to
create. I will use this column to then create a pivot table.:
$0 - $10
$10.01 - $20
$20.01 - $100
$100.01 - $500.00
$500.01 - $1000.00
$1000.01 +
I have all types of dollar ranges
--
Thanks for your help!
Walter
"Peo Sjoblom" wrote:
One way
=VLOOKUP(D1,{0,"$0.00 - $10.00";10.01,"$10.01 - $20.00";20.01,"$20.01 -
$30.00"},2)
where D1 is the cell you put the value
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"BARRIOSWJ" wrote in message
...
I want to create the following formula.
Dollar amount is located on Column E and I want to put this formula on
column G
If $0.00 - $10.00 Put "$0.00 - $10.00"
If $10.01 - $20.00 Put "$10.00 - $20.00"
If $11.01 - $30.00 Put " $20.00 - $30.00"
Etc. Etc. Im sure you got the idea. I hope you can help. Thanks.
--
Thanks for your help!
Walter