Hi All
I have just got back into excel after some years of absence and have a problem which I cannot seem to solve, so ask the experts.
I have the above table showing a team, Wellington Phoenix and the last four actual games with dates. I have a simple formula in R1 column which is just "H" minus "A".
In R2 I have the following formula which refers to R1 column =IF(P2<>"",IF(P2>0,"W",IF(P2<0,"W",IF(P2=0,"D","L")))). This is fine for the actual result of the match but I want R2 to show the actual Wellington Phoenix result. As you can see in the sixth result it is showing a win when in fact Wellington lost.
Is there a formula that can capture what the result is for Wellington whether or not they are home or away?
Any help or assistance would be gratefully received.
Thanks
William
I have just got back into excel after some years of absence and have a problem which I cannot seem to solve, so ask the experts.
I have the above table showing a team, Wellington Phoenix and the last four actual games with dates. I have a simple formula in R1 column which is just "H" minus "A".
In R2 I have the following formula which refers to R1 column =IF(P2<>"",IF(P2>0,"W",IF(P2<0,"W",IF(P2=0,"D","L")))). This is fine for the actual result of the match but I want R2 to show the actual Wellington Phoenix result. As you can see in the sixth result it is showing a win when in fact Wellington lost.
Is there a formula that can capture what the result is for Wellington whether or not they are home or away?
Any help or assistance would be gratefully received.
Thanks
William