| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need and and/or statement
I believe I am looking for an OR statement, but I need help.
In column A, I can have either "13A" or "20", if it's either of those two numbers I want to put a 1 in column B, if it's not either of those numbers I want to put a 0 in column B. Can somebody help me write this formula. Thanks in advance for your help -- DMM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need and and/or statement
Hi,
in column B enter =if(or(A1="13A",A1=20),1,0) "soconfused" wrote: I believe I am looking for an OR statement, but I need help. In column A, I can have either "13A" or "20", if it's either of those two numbers I want to put a 1 in column B, if it's not either of those numbers I want to put a 0 in column B. Can somebody help me write this formula. Thanks in advance for your help -- DMM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need and and/or statement
Thank you, that works perfectly.
-- DMM "Eduardo" wrote: Hi, in column B enter =if(or(A1="13A",A1=20),1,0) "soconfused" wrote: I believe I am looking for an OR statement, but I need help. In column A, I can have either "13A" or "20", if it's either of those two numbers I want to put a 1 in column B, if it's not either of those numbers I want to put a 0 in column B. Can somebody help me write this formula. Thanks in advance for your help -- DMM |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need and and/or statement
your welcom, have a great day
"soconfused" wrote: Thank you, that works perfectly. -- DMM "Eduardo" wrote: Hi, in column B enter =if(or(A1="13A",A1=20),1,0) "soconfused" wrote: I believe I am looking for an OR statement, but I need help. In column A, I can have either "13A" or "20", if it's either of those two numbers I want to put a 1 in column B, if it's not either of those numbers I want to put a 0 in column B. Can somebody help me write this formula. Thanks in advance for your help -- DMM |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need and and/or statement
=OR(A1={"13A",20})+0
"soconfused" wrote: I believe I am looking for an OR statement, but I need help. In column A, I can have either "13A" or "20", if it's either of those two numbers I want to put a 1 in column B, if it's not either of those numbers I want to put a 0 in column B. Can somebody help me write this formula. Thanks in advance for your help -- DMM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
