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