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