R1 R2 R3 R4 R5 Current Streak Current Winning Streak Current Losing Streak Current Drawing Streak
72 BYE 50 55 W3 W3 L0 D0
40 -25 25 BYE W1 W1 L0 D0
40 -25 -25 BYE D1 W0 L0 D1
40 -25 0 BYE D1 W0 L0 D1

I'm trying to find a formula that can work out the current streak/current winning-losing-drawing streak.

This formula here only works if there is no byes/or blanks.

=MAX(0,MAX((A2:E5>0)*COLUMN(A2:E5))-MAX((A2:E5<=0)*COLUMN(A2:E5)))

The first 5 columns are the margins for each team.
Positive margin = Win
"0" Margin = Draw
Negative Margin = Loss

Round 5 hasn't been played yet.