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

=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

On 5/18/2010 11:09, Don Guillett wrote:
=IF(LEN(TRIM(E12))=0,"",IF(OR(E12=0%,E12=100%),"cl osed","open"))


THanks Don. Worked perfectly.

Hello, For multiple conditioned IF function, it would be best to use the IFS Function in excel.

IFS function work the same as the IF function, but:

=ifs(Logical test 1, value if true1, logical test 2, value if true 2...)

this can hold more conditions that your usual if function. it also makes things easier to type and look at. Hope this helps!