software

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 quot;$0.00 - $10.00quot;
If $10.01 - $20.00 Put quot;$10.00 - $20.00quot;
If $11.01 - $30.00 Put quot; $20.00 - $30.00quot;

Etc. Etc. Im sure you got the idea. I hope you can help. Thanks.
--
Thanks for your help!

Walter

One way

=VLOOKUP(D1,{0,quot;$0.00 - $10.00quot;;10.01,quot;$10.01 - $20.00quot;;20.01,quot;$20.01 -
$30.00quot;},2)

where D1 is the cell you put the value--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;BARRIOSWJquot; gt; wrote in message
...
gt;I want to create the following formula.
gt;
gt; Dollar amount is located on Column E and I want to put this formula on
gt; column G
gt;
gt; If $0.00 - $10.00 Put quot;$0.00 - $10.00quot;
gt; If $10.01 - $20.00 Put quot;$10.00 - $20.00quot;
gt; If $11.01 - $30.00 Put quot; $20.00 - $30.00quot;
gt;
gt; Etc. Etc. Im sure you got the idea. I hope you can help. Thanks.
gt; --
gt; Thanks for your help!
gt;
gt; Walter
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!

Walterquot;Peo Sjoblomquot; wrote:

gt; One way
gt;
gt; =VLOOKUP(D1,{0,quot;$0.00 - $10.00quot;;10.01,quot;$10.01 - $20.00quot;;20.01,quot;$20.01 -
gt; $30.00quot;},2)
gt;
gt; where D1 is the cell you put the value
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;BARRIOSWJquot; gt; wrote in message
gt; ...
gt; gt;I want to create the following formula.
gt; gt;
gt; gt; Dollar amount is located on Column E and I want to put this formula on
gt; gt; column G
gt; gt;
gt; gt; If $0.00 - $10.00 Put quot;$0.00 - $10.00quot;
gt; gt; If $10.01 - $20.00 Put quot;$10.00 - $20.00quot;
gt; gt; If $11.01 - $30.00 Put quot; $20.00 - $30.00quot;
gt; gt;
gt; gt; Etc. Etc. Im sure you got the idea. I hope you can help. Thanks.
gt; gt; --
gt; gt; Thanks for your help!
gt; gt;
gt; gt; Walter
gt;
gt;
gt;