Thread: how to combine and's with or's in a if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rick is offline
external usenet poster
  
Posts: 334
Default how to combine and's with or's in a if statement
If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack
Reply With QuoteReply With Quote