| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula
i am trying to find/create a formula with the following information but have
seem to hit a wall i will try to explain if b1 is greater than or equal to 20 than b2 is 25 or b1 is greater than or equal to 15 but less than 20 b2 is 20 or b1 is greater than or equal to 10 but less than 15 b2 is 15 or b1 is greater than or equal to 2 but less than 10 b2 is 10 or b1 is greater than or equal to 1 but less than 2 b2 is 5 or b1 is less than 1 than b2 is 0 thanks for any ifo available |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formula
Phil
Build a table somewhere out of the way that looks like this which in my case is in my case is in 01 - P6 then put this formula in b2. Note if you add more values column O must remain sorted. =VLOOKUP(B1,O1:P6,2,1) 0 0 1 5 2 10 10 15 15 20 20 25 Mike "phil" wrote: i am trying to find/create a formula with the following information but have seem to hit a wall i will try to explain if b1 is greater than or equal to 20 than b2 is 25 or b1 is greater than or equal to 15 but less than 20 b2 is 20 or b1 is greater than or equal to 10 but less than 15 b2 is 15 or b1 is greater than or equal to 2 but less than 10 b2 is 10 or b1 is greater than or equal to 1 but less than 2 b2 is 5 or b1 is less than 1 than b2 is 0 thanks for any ifo available |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formula
thanks i finally got it to work after a little tweaking
"Mike H" wrote: Phil Build a table somewhere out of the way that looks like this which in my case is in my case is in 01 - P6 then put this formula in b2. Note if you add more values column O must remain sorted. =VLOOKUP(B1,O1:P6,2,1) 0 0 1 5 2 10 10 15 15 20 20 25 Mike "phil" wrote: i am trying to find/create a formula with the following information but have seem to hit a wall i will try to explain if b1 is greater than or equal to 20 than b2 is 25 or b1 is greater than or equal to 15 but less than 20 b2 is 20 or b1 is greater than or equal to 10 but less than 15 b2 is 15 or b1 is greater than or equal to 2 but less than 10 b2 is 10 or b1 is greater than or equal to 1 but less than 2 b2 is 5 or b1 is less than 1 than b2 is 0 thanks for any ifo available |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formula | Excel Discussion (Misc queries) | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Conditional formula | Excel Worksheet Functions | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Linear Mode
