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

Dollar Ranges
 

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

IF Formula, Dollar Ranges
 

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