| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollar sign alignment - Accounting vs Currency style | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
