1) Excel formula for the following:
If AC is greater than 1.30 but less than 1.45 and AD minus AC is greater than 0.5 then show as W.
If AD is greater than 1.30 but less than 1.45 and AD minus AC is greater than 0.5 show as L.
Otherwise show 0
2) Excel formula for winning and losing runs.
I want to know the longest run of consecutive W and also the longest run of consecutive L
3) Sample data set
In the attachment is a sample of the data set on which you can use to test your equations and display the results to me.