Forum Discussion
Football Pool Sheet Using Logical Formula
I run a local football pool and I developed a great spreadsheet, but I want to add another wrinkle to it I type in a W or L based on the result of the score to each teams spread I copy and paste al...
That must be an image pasted onto a spreadsheet because your columns don't line up. That said and I don't like using merged cells, I recreated it using columns A-E. Based on that (see attached)..
Here is an option:
=SWITCH(SIGN(IF(ISODD(ROW(C3:C8)),E3#,-E2:E7)-C3:C8),1,"W",0,"T",-1,"L")I also used a formula to create that difference column:
=IF(ISODD(ROW(D3:D8)),D3:D8-D4:D9,"("&D2:D7&"-"&D3:D8&")")