If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with If statement
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 |
#2
|
|||
|
|||
Help with If statement
=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 |
#3
|
|||
|
|||
Help with If statement
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. |
Thread Tools | |
Display Modes | |
|
|