Yes this is possible and the following is one of the possible solutions
(on the presumption that when both the columns E and F are blanks then
column G would remain blank) :-

Enter this formula in G2

=IF(AND(NOT(ISBLANK(E2)),NOT(ISBLANK(F2))), IF(E2 = F2, "P", "D"), "")


Best regards


Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=388539