Forum Discussion

KUKS_42's avatar
KUKS_42
Copper Contributor
Nov 08, 2025

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 all the scores based on rotation so its easier to sort

I want to have the formula automatically insert a "W" or "L" based on the difference in score and spread after i paste all the scores

If you think I need to add or do something else to make it easier, please let me know

I WOULD LOVE TO KNOW HOW TO LINK LIVE TIME SCORES WITH A WEBSITE, BUT ONE STEP AT A TIME LOL

THANK YOU!!!!!

 

community
excel
Formulas and Functions
office 365

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Nov 08, 2025

    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&")")

     

Resources