+ Reply to Thread
Results 1 to 2 of 2

Logical test function problem

  1. #1
    Registered User
    Join Date
    01-09-2008
    Posts
    3

    Logical test function problem

    Cell AJ14 needs to display the text letter X, text letter E, or remain blank based on the following:

    If FC4=X then AJ14 needs to be X.
    If FC4 is blank AND FE4 and FQ4 are both X, or FE4 and FL4 are both X, then AJ14 needs to be E.

    Thanks for any help!
    Tom

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try this formula in AJ14

    =IF(FC4="X","X",IF(AND(FC4="",FE4="X",OR(FQ4="X",FL4="X")),"E",""))

+ Reply to Thread

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