Hi, thanks for taking the time to try and help me.
Below is my data
A B C D
1: Name hole 1 hole 2 hole 3
2: Mike 5 5 4
3: Dave 4 5 6
4: Dave stroke n y n
5: Dave points
We get 2 points for winning the hole, 1 for a tie, 0 for a loss.
I have figured out that for B5 =if(B3<B2,2,if(B3=B2,1,0) works fine
However, if Dave is getting a stroke on Hole 2, his 5 turns into a 4 (dave net)
I want to create a formula that says if C4=y then =if(C3-1<C2,2,if(C3-1=C2,1,0) but if C4=n then =if(C3<C2,2,if(C3=C2,1,0)
Hope thats not too confusing.
Thank you in advance!
Bookmarks