Thread: Help with formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
smartin smartin is offline
external usenet poster
  
Posts: 915
Default Help with formula
gcotterl wrote:
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?

see other post
Reply With QuoteReply With Quote