Alex, see attached in green.
the formula yielded 1 for both, i.e. When Goal Up then Gives Lead Back.
is that what you're expected.
have you changed Columns E & F? as the formula use them
Alex, see attached in green.
the formula yielded 1 for both, i.e. When Goal Up then Gives Lead Back.
is that what you're expected.
have you changed Columns E & F? as the formula use them
Last edited by AlanY; 12-02-2014 at 06:47 AM.
I have only played around with a view possible results and added goal minutes based on these scenarios. For example if I know change the 2nd green line, the goal minutes to 15, 22 and leave 10,20 for the second game the score would be that Team 2 goes 1:0 up, then Team 1 equalises (gets deficit back yes) and team 2 loses goal advantage but the formula says Team 1 (4 When Goal Down Gets Deficit Back No) and Team 2 (2 When Goal Up Gives Lead Back No.) Even though Team 2 lost the lead twice and Team 1 recovered twice. Does that help?
Again thanks for your help, really appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks