Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - And - Then Statement question
Could you help me to write and if-and-then statement?
example: Col A Col B C BSY I am trying to have the statement read: IF Column A = C AND Column B = BSY, THAN Column A = W |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - And - Then Statement question
You won't be able to do that. A formula returns a result to the cell
that it sits in, so it would have to be in column A in order to return a value there. Consequently, it cannot refer to itself (circular reference). However, if you put the formula in C2, then you could have this: =IF(AND(A2="C",B2="BSY"),"W","") This will return a "W" in C2 if the two conditions are met, otherwise C2 will appear blank. Hope this helps. Pete On Sep 19, 3:03*pm, MayJuneJuly wrote: Could you help me to write and if-and-then statement? example: Col A * *Col B * C * * * BSY I am trying to have the statement read: IF Column A = C AND Column B = BSY, THAN Column A = W |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - And - Then Statement question
What about VBA?
"Pete_UK" wrote: You won't be able to do that. A formula returns a result to the cell that it sits in, so it would have to be in column A in order to return a value there. Consequently, it cannot refer to itself (circular reference). However, if you put the formula in C2, then you could have this: =IF(AND(A2="C",B2="BSY"),"W","") This will return a "W" in C2 if the two conditions are met, otherwise C2 will appear blank. Hope this helps. Pete On Sep 19, 3:03 pm, MayJuneJuly wrote: Could you help me to write and if-and-then statement? example: Col A Col B C BSY I am trying to have the statement read: IF Column A = C AND Column B = BSY, THAN Column A = W |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - And - Then Statement question
Yes, it could be done with a macro, but as you posted in the Functions
group I though you were looking for a formulaic solution. Pete On Sep 19, 3:41*pm, MayJuneJuly wrote: What about VBA? "Pete_UK" wrote: You won't be able to do that. A formula returns a result to the cell that it sits in, so it would have to be in column A in order to return a value there. Consequently, it cannot refer to itself (circular reference). However, if you put the formula in C2, then you could have this: =IF(AND(A2="C",B2="BSY"),"W","") This will return a "W" in C2 if the two conditions are met, otherwise C2 will appear blank. Hope this helps. Pete On Sep 19, 3:03 pm, MayJuneJuly wrote: Could you help me to write and if-and-then statement? example: Col A * *Col B * C * * * BSY I am trying to have the statement read: IF Column A = C AND Column B = BSY, THAN Column A = W- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - And - Then Statement question
Thank you...VBA came to mind after I read your answer. You have been very
helpful. I will post my question to the correct group. "Pete_UK" wrote: Yes, it could be done with a macro, but as you posted in the Functions group I though you were looking for a formulaic solution. Pete On Sep 19, 3:41 pm, MayJuneJuly wrote: What about VBA? "Pete_UK" wrote: You won't be able to do that. A formula returns a result to the cell that it sits in, so it would have to be in column A in order to return a value there. Consequently, it cannot refer to itself (circular reference). However, if you put the formula in C2, then you could have this: =IF(AND(A2="C",B2="BSY"),"W","") This will return a "W" in C2 if the two conditions are met, otherwise C2 will appear blank. Hope this helps. Pete On Sep 19, 3:03 pm, MayJuneJuly wrote: Could you help me to write and if-and-then statement? example: Col A Col B C BSY I am trying to have the statement read: IF Column A = C AND Column B = BSY, THAN Column A = W- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement question | Excel Discussion (Misc queries) | |||
If then statement question.... | New Users to Excel | |||
IF then statement question | Excel Discussion (Misc queries) | |||
If Statement Question | Excel Worksheet Functions | |||
IF Statement question | Excel Worksheet Functions |