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.

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" ,"")))))))

This looks to me to be much to complex for a 'simple' excel formula....
Maybe you should make it into a function....

Regards