Thread: Multiple Condition syntax needed
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jetheat[_3_] Jetheat[_3_] is offline
external usenet poster
  
Posts: 1
Default Multiple Condition syntax needed
Its ok, figured it out from another guy,

=IF(AND(D5<"B",D5<"S"),"",IF(OR(AND(D5="S",F5<E5 ),AND(D5="B",F5E5)),"Profit","Loss"))

Thank

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote