B bob Jun 25, 2004 #1 Can this formula IF(C9=O5, "Yes", "No") and this formula IF(D9=P5, "Yes", "No") Be combined? Please help
Can this formula IF(C9=O5, "Yes", "No") and this formula IF(D9=P5, "Yes", "No") Be combined? Please help
P Peo Sjoblom Jun 25, 2004 #2 =IF(AND(C9=O5,D9=P5),"Yes","No") or maybe =IF(OR(C9=O5,D9=P5),"Yes","No") the former demands that both conditions are TRUE, the latter one OR the other -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
=IF(AND(C9=O5,D9=P5),"Yes","No") or maybe =IF(OR(C9=O5,D9=P5),"Yes","No") the former demands that both conditions are TRUE, the latter one OR the other -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
