Thread: Help with If statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
  
Posts: 209
Default 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.
Reply With QuoteReply With Quote