I need a formula that if A1 increases from 0 to 4 C1 will go to 4, but if anytime b1 increases, c1 resets to 0 and -1. It also increases -2 if the next time b1 increases.
I am adding this for help since I am not sure how helpful above is. Think W/L A1 is wins. B1 is loss. C1 is streak. Every time A1 or B1 goes up C1 must reset to 0 and then either go +1 or -1. If A1 increases 4 times in a row, C1 should be 4 or +4 same goes for b1 if that happens in a row. But if A1 goes up 3 times and then B1 goes up next C1 goes from 3 to -1. I hope that is more clear.
Tim
Bookmarks