Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
Let's try this again!
This is what I want to do. I want a cell to put the following If E2 (contains the invoice amount) is between $0 and $50 put "$0 - $50.00" in the cell. If E2 is between $50.01 - $100 put "$50 -$100" If E2 is between $100.01 - $500 put "$100 - $500" If E2 is between $500.01 - $1000.00 put $500 - $1000" And if it's over $1000.01 then put "1000+" How do I make this into a formula? -- Thanks for your help! Walter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
the Vlookup reply should work.
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
Can you create the formula for me using the Vlookup? Please? Thanks.
-- Thanks for your help! Walter " wrote: the Vlookup reply should work. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
Pretty sure it was in your previous thread! Sorry:)
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
Is this what you are looking for ???
=IF(AND(E2=0,E2<=50),"$0 - $50.00",IF(AND(E2=50.01,E2<=100),"$50.01 - $100",IF(AND(E2=100.01,E2<=500),"$100.01 - $500",IF(AND(E2=500.01,E2<=1000),"$500.01 - $1,000.00",IF(E2=1000.01,"1,000+","Other"))))) "BARRIOSWJ" wrote: Can you create the formula for me using the Vlookup? Please? Thanks. -- Thanks for your help! Walter " wrote: the Vlookup reply should work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |