Thread: nested If
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Shultz Dave Shultz is offline
external usenet poster
  
Posts: 14
Default nested If
Heres my dilemma:
If cell I5 is null and J5 is null, I want L5 to be null
If I5 is not null and J5 is null, I want L5 to return €śIn Progress€ť
If I5 is not null and J5 is not null, I want L5 to return €śClosed€ť
Any suggestions???

Reply With QuoteReply With Quote