Thread: Dollar Ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BARRIOSWJ
 
Posts: n/a
Default Dollar Ranges

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