| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula question
Ok, I should be able to do this and just can't get it to work.
Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
Use the following syntax:
=IF(B1<6500,0,IF(AND(B116500,B11<8000),150.... Make sure your parentheses are correct. Dave -- Brevity is the soul of wit. "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
And don't forget equal signs for the event X=6500 etc.
=IF(B1<=6500,0,IF(AND(B116500,B11<=8000),150.... Beege "Dave F" wrote in message ... Use the following syntax: =IF(B1<6500,0,IF(AND(B116500,B11<8000),150.... Make sure your parentheses are correct. Dave -- Brevity is the soul of wit. "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
Thank you Dave.
Now I did that. and it gives me #value. I checked ()'s and didn't see anything. Am I doing something else wrong? =IF(B11<6500,0),IF(AND(B116500,B11<8000),150),IF( AND(B118001,B11<10000),300),IF(AND(B1110000),500 ) "Dave F" wrote: Use the following syntax: =IF(B1<6500,0,IF(AND(B116500,B11<8000),150.... Make sure your parentheses are correct. Dave -- Brevity is the soul of wit. "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
This may do what you are asking: Note, there were some holes, so I
arbitrarily changed < to <= or to = in certain places (otherwise it returned false, for say 8000.) =IF(B11<=6500,0,IF(AND(B116500,B11<=8000),150,IF( AND(B11=8001,B11<=10000),300,IF(B1110000,500)))) -- Kevin Vaughn "sssspro" wrote: Thank you Dave. Now I did that. and it gives me #value. I checked ()'s and didn't see anything. Am I doing something else wrong? =IF(B11<6500,0),IF(AND(B116500,B11<8000),150),IF( AND(B118001,B11<10000),300),IF(AND(B1110000),500 ) "Dave F" wrote: Use the following syntax: =IF(B1<6500,0,IF(AND(B116500,B11<8000),150.... Make sure your parentheses are correct. Dave -- Brevity is the soul of wit. "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
But if you've got a first condition of IF(B11<=6500,... (assuming that the
B1 was a misprint for B11), then you don't need the test for B116500 in the second IF statement. -- David Biddulph "Beege" wrote in message . .. And don't forget equal signs for the event X=6500 etc. =IF(B1<=6500,0,IF(AND(B116500,B11<=8000),150.... Beege "Dave F" wrote in message ... Use the following syntax: =IF(B1<6500,0,IF(AND(B116500,B11<8000),150.... Make sure your parentheses are correct. Dave -- Brevity is the soul of wit. "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula question
TRY...
=IF(B11=10000,500,IF(B11=8000,300,IF(B11=6500,1 50,0))) I PLACE SOME ADJUSTMENTS BASED ON THE MID OF " <"... U CAN REMOVE "=" IF IT WILL FIT YOU... "sssspro" wrote: Ok, I should be able to do this and just can't get it to work. Here's the deal, I need a formula to do this: If cell B11 is < 6500 then return 0 If cell B11 is 6500 and <8000 return 150 If cell B11 is 8000 and < 10000 return 300 If cell B11 is 10000 return 500 Here's what I've got and it isn't working, any help would be appreciated: (Sarah feeling stupid this morning) - I know it is something simple I am missing here. Thanks for that help!!!! =IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000, 300,0)=IF(B1110001, 500,0) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Copy Formula with Linked Cells - Validation Question | Links and Linking in Excel | |||
| Formula question | Excel Worksheet Functions | |||
| Repeating Formula Question | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
Linear Mode
