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