View Single Post
  #1   Report Post  
excel novice
 
Posts: n/a
Default how to use if,and,or functions together in excel

I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me answer of OK,
otherwise NOT OK