Help with If statement

  • Thread starter Thread starter gls858
  • Start date Start date
G

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
 
Back
Top