Hi worthingto and welcome to the forum,
Change the first formula to:
then make the second formula![]()
=IF((D4+C4)>(L4+M4),1, IF((D4+C4)=(L4+M4), .5,0))
The idea here is instead of making a Win = True, you will make it a 1. Also a tie will be = .5.![]()
=Sum(D16:D20)
I hope this makes sense and helps. If not you need to attach your workbook so we can see what is happening. You can do that by clicking on "Go Advanced" and then the Paper Clip Icon above the advanced message area.
Bookmarks