how do i add formulas together

[jono121ukk]

trying to add the following together

=IF(OR(Z168=K168,AI168=M168),"win","-")
and
=IF(OR(AC169=K169,AF169=K169,),"h/d","-")
and
=IF(OR(AO170=M170,AL170=M170,),"a/d","-")

is this possible

thanks

[sandy666]

not tested: =IF(OR(Z168=K168,AI168=M168),"win",IF(OR(AC169=K169,AF169=K169,),"h/d",IF(OR(AO170=M170,AL170=M170,),"a/d","-")))

[jono121ukk]

bang on thank you

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[sandy666]

You are welcome

repsolv.gif