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