| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Or Statement
Hello,
I am having a little trouble with this formula and was hoping for some help. =IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???")))) If N1 equals "government" AND (V1 is 7 and less than 100) OR (W1 is 0 and less than 100) then return "Yes". If not, return "No. The first part of the formula works fine for "bond" and "other" Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Or Statement
Maybe you're looking for something like this:
=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(AND(V17, V1<100),AND(W10,W1<100))),"Yes","No")))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "nabanco" wrote: I am having a little trouble with this formula and was hoping for some help. =IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???")))) If N1 equals "government" AND (V1 is 7 and less than 100) OR (W1 is 0 and less than 100) then return "Yes". If not, return "No. The first part of the formula works fine for "bond" and "other" Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Or Statement
Max, that worked perfectly, thank you sir
"Max" wrote: Maybe you're looking for something like this: =IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(AND(V17, V1<100),AND(W10,W1<100))),"Yes","No")))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "nabanco" wrote: I am having a little trouble with this formula and was hoping for some help. =IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???")))) If N1 equals "government" AND (V1 is 7 and less than 100) OR (W1 is 0 and less than 100) then return "Yes". If not, return "No. The first part of the formula works fine for "bond" and "other" Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Or Statement
Welcome, nabanco.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "nabanco" wrote in message ... Max, that worked perfectly, thank you sir |
| 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 + LEN | 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 | |||
Linear Mode
