Help with If statement

[gls858]

I have this If statement in H12 and it works except when E12 is blank I
want H12 to be blank.

=IF(E12=0%,"Closed",IF(E12=100%,"closed","open"))

I'm not sure how to make that happen. Could someone please help me.

TIA
gls858

 

[Don Guillett]

=IF(LEN(TRIM(E12))=0,"",IF(OR(E12=0%,E12=100%),"closed","open"))

 

[gls858]

=IF(LEN(TRIM(E12))=0,"",IF(OR(E12=0%,E12=100%),"closed","open"))

THanks Don. Worked perfectly.