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)","")) |
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)","")) |
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)","")) |
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)","")) |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com