Need some help to develop a formula that can show me a value if it satisfies 4conditions. Attached is a sheet that shows the data.
Need a formula that will use column F as a reference to find out if there are 3 previous wins and show the value of FG (H column) and if not it should return just a character ("-" eg). For example in our case the end result should be what is shown in column J. The problem I have is that the sheet contains a break in stats after every 20 games and more conditions have to be added to accomodate this and have not been able to succesfully do it. You can use other columns (as shown) for references if it is easier. See column L for what I have come up with but it does not quite work as I wanted it - as it shows a false where it should return just "-" and also in the row after the last data entry it shows a 0 instead of "-". Table gets updated.
Any other solution (not using IF function) would be fine as long as I get the end result in column J (as shown).
Appreciate your help.
Bookmarks