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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gls858" wrote in message
...
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