Results 1 to 11 of 11

How do I evaluate a pair of cells

Threaded View

  1. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: How do I evaluate a pair of cells

    In a7:

    =CHOOSE(AND(A2>30,B2>30)*1+1,"fail","pass")

    Copy down through A10, don't need a macro.


    edit- added attachment
    Attached Files Attached Files
    Last edited by GeneralDisarray; 06-29-2012 at 10:28 AM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1