Results 1 to 2 of 2

Thread: 2010

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2010

    Hi, I need a formula to return true from a combination of values from two cells, for instance I want the value to be true if say cell A1 = 1 and cell B1 =2 or 3, any other combinations would be false.

    Kind regards Darren

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try this....
    =AND(A1=1,OR(B1=2,B1=3))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •