I have two checkbox fields basically "#OPEN" and "#CLOSED". Bad design, I know, but not my doing! Anyway, I want to combine them into a single field with an IF statement.

Essentially, something like IF(#OPEN=TRUE, "Open", "Closed")

But I don't know how to treat the check in a checkbox. Is it "TRUE"? I keep getting a syntax error. 

Hope that's not confusing. This should be easy...

I have two checkbox fields basically "#OPEN" and "#CLOSED". Bad design, I know, but not my doing! Anyway, I want to combine them into a single field with an IF statement.

Essentially, something like IF(#OPEN=TRUE, "Open", "Closed")

But I don't know how to treat the check in a checkbox. Is it "TRUE"? I keep getting a syntax error. 

Hope that's not confusing. This should be easy...