Thread: If Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lizz45ie Lizz45ie is offline
external usenet poster
 
Posts: 20
Default If Function

I am trying to add another criteria to a "IF function" that isn't working.
My current IF statement is:

IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1)

this formula works fine but when I added AL3="USMC" to the end of the
formula it no longer returns the expected result. What do I need to add to
the formula so that it returns an answer if AL3="USMC" also. Any help is
appreciated.