p q r s t
5 Opp Ven H A Form
6 Bournemouth H 1 2 L
=IF(R4="","",IF(R4>S4,"W",IF(R4=S4,"D",IF(R4<S4,"L"))))
Hi I have the above table in excel.
I need a formula that works out the same as the formula above when q6 is H however reverses this if q6 is A
5 Opp Ven H A Form
6 Bournemouth H 1 2 L
=IF(R4="","",IF(R4>S4,"W",IF(R4=S4,"D",IF(R4<S4,"L"))))
Hi I have the above table in excel.
I need a formula that works out the same as the formula above when q6 is H however reverses this if q6 is A