Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
Hi,
I'm having a little problem figuring this one out. I'm trying to create a statement in excel 2003 that would accomplish the below: If A1="X", then return "complete" If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other". If N1 equals "Government", then we need to return "Yes" if V1 is greter than 7 OR W1 is greater than 1. Thanks for any help you can provide, this one is way above me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
What if A1 is not X and not is blank?
If N1 = "Government" and A1 not is blank, then...? What if V1 not greater than 7 and W1 not greater than 1? I probably missed a few. Please specify *exactly* what the requirements are. "nabanco" wrote in message ... | Hi, | | I'm having a little problem figuring this one out. I'm trying to create a | statement in excel 2003 that would accomplish the below: | | If A1="X", then return "complete" | | If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other". | If N1 equals "Government", then we need to return "Yes" if V1 is greter than | 7 OR W1 is greater than 1. | | Thanks for any help you can provide, this one is way above me. | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
I'm not sure if this does what you want or not, so you will have to test it to see...
=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???")))) Note there is a "???" at the end of the formula... you didn't state a return value for this fall through condition, so I used "???"... perhaps you simply want to return a blank for it (just use "" instead of "???" if that is the case). Rick "nabanco" wrote in message ... Hi, I'm having a little problem figuring this one out. I'm trying to create a statement in excel 2003 that would accomplish the below: If A1="X", then return "complete" If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other". If N1 equals "Government", then we need to return "Yes" if V1 is greter than 7 OR W1 is greater than 1. Thanks for any help you can provide, this one is way above me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
Good point.
If A1 is blank, then the other rules below should apply. In other words, we are pivoting out only the answers that return "Yes". If they are blank or "complete", we are not using them in our pivot table. Below is the current statement we use, but the columns have changes somewhat if this helps. =IF(A455="X","Complete",IF(AND(V455=1,V455<=100), "YES","")) If we need to place something there, then we could return "No" if the rules do not apply If V1 not greater than 7 and W1 not greater than 1 then return "No" Is that clear as mud? "Niek Otten" wrote: What if A1 is not X and not is blank? If N1 = "Government" and A1 not is blank, then...? What if V1 not greater than 7 and W1 not greater than 1? I probably missed a few. Please specify *exactly* what the requirements are. "nabanco" wrote in message ... | Hi, | | I'm having a little problem figuring this one out. I'm trying to create a | statement in excel 2003 that would accomplish the below: | | If A1="X", then return "complete" | | If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other". | If N1 equals "Government", then we need to return "Yes" if V1 is greter than | 7 OR W1 is greater than 1. | | Thanks for any help you can provide, this one is way above me. | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
Rick, thank you so much, that worked beautifully
"Rick Rothstein (MVP - VB)" wrote: I'm not sure if this does what you want or not, so you will have to test it to see... =IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???")))) Note there is a "???" at the end of the formula... you didn't state a return value for this fall through condition, so I used "???"... perhaps you simply want to return a blank for it (just use "" instead of "???" if that is the case). Rick "nabanco" wrote in message ... Hi, I'm having a little problem figuring this one out. I'm trying to create a statement in excel 2003 that would accomplish the below: If A1="X", then return "complete" If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other". If N1 equals "Government", then we need to return "Yes" if V1 is greter than 7 OR W1 is greater than 1. Thanks for any help you can provide, this one is way above me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
If statement | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |