Dollar Ranges

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

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

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