Thread: Help with formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
  
Posts: 83
Default Help with formula
If M6 = "J" or "L"
if the third character in M6 = "-"
I want S6 to contain ""X"
else, I want S6 to contain "Y"
else, I want S6 to contain "Z"
else, I want S6 to contain "Z"



How do I write the formula?
Reply With QuoteReply With Quote