Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statment help
Hello everyone, I put this code into A10, I need A10 (as it will populate as
"(Open)to also populate into cell C4 but I need to be able to add more text into cell C4 as (open) will be the end statment, any ideas? =IF(OR(C1="Open",C1="N/A",),"(Open)",IF(C1="Closed","(Closed)","")) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statment help
Hi
I am not sure that I understand your question, do you want to have the text (Open) and (Closed) in cell C4? Would you provide a sample of what you want to achieve? -- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "Joe Wildman" wrote: Hello everyone, I put this code into A10, I need A10 (as it will populate as "(Open)to also populate into cell C4 but I need to be able to add more text into cell C4 as (open) will be the end statment, any ideas? =IF(OR(C1="Open",C1="N/A",),"(Open)",IF(C1="Closed","(Closed)","")) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statment help
Never mind I linked the cell A33 with the code and used cell c4 as the input
line, it works nice! "Joe Wildman" wrote: Hello everyone, I put this code into A10, I need A10 (as it will populate as "(Open)to also populate into cell C4 but I need to be able to add more text into cell C4 as (open) will be the end statment, any ideas? =IF(OR(C1="Open",C1="N/A",),"(Open)",IF(C1="Closed","(Closed)","")) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statment help
glad that you've found a solution.
-- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "Joe Wildman" wrote: Never mind I linked the cell A33 with the code and used cell c4 as the input line, it works nice! "Joe Wildman" wrote: Hello everyone, I put this code into A10, I need A10 (as it will populate as "(Open)to also populate into cell C4 but I need to be able to add more text into cell C4 as (open) will be the end statment, any ideas? =IF(OR(C1="Open",C1="N/A",),"(Open)",IF(C1="Closed","(Closed)","")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with If statment | Excel Discussion (Misc queries) | |||
If statment | Excel Discussion (Misc queries) | |||
if statment | Excel Worksheet Functions | |||
If statment if its possible. | Excel Discussion (Misc queries) | |||
If statment | Excel Worksheet Functions |