Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Red face Unanswered: If/And help - I think....

    Hi,

    I am trying to compare two different cells - where one
    cell displays - CR, PR, SD, PD and the other cell
    displays CR, SD, PD.

    What I need to do is have the 3rd cell - where I want to
    display a result based on the combination of the 2
    previous cells:

    If Cell 1 or Cell 2 = PD then Cell 3 = PD
    If Cell 1 = SD and Cell 2 does not equal PD then Cell 3 =
    SD
    If Cell 1 = PR and Cell 2 does not equal PD then Cell 3 =
    PR
    If Cell 1 = CR and Cell 2 = SD then Cell 3 = PR
    If Cell 1 = CR and Cell 2 = CR then Cell 3 = CR

    I have tried the following formula in Cell 3 (with Cell 1
    being d21 and Cell 2 = d22):

    =if (d21="pd","pd",if (d22="pd","pd")),and(d21="SD",
    d22<>"PD", "SD"),and(d21="PR",d22<>"PD", "PR"),and
    (d21="CR",d22="SD", "PR"), and(d21="CR", d22="CR", "CR")

    Any help would be greatly appreciated. I think I am on
    the right track but not sure. Thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Posts
    7
    okay - I got the answer off of the microsoft newsgroup - thanks to Bob

    Here is the formula:

    =IF((OR(A1="PD",B1="PD")),"PD",(IF(AND(A1="SD",B1< >"PD"),"SD",IF(AND(A1="PR",B1<>"PD"),"PR",(IF(AND( A1="CR",B1="SD"),"PR",IF(AND(A1="CR",B1="CR"),"CR" ,"")))))))

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    This looks to me to be much to complex for a 'simple' excel formula....
    Maybe you should make it into a function....

    Regards

Posting Permissions

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