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)",""))