Forum Discussion

JWhite91's avatar
JWhite91
Copper Contributor
Apr 23, 2021

Looking for excel formula to calculate win%.

Hello,

New to excel and looking for a formula to basically calculate win %. The picture is how my current W/L table is set up.

Thank you in advance
Formulas and Functions

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 23, 2021

    JWhite91 In it's simplest form that would be in E4:

    =C4/(C4+D4)*100

    and copy down. You could leave out the *100 at the end and format cells in E as a percentage with the desired number of decimals, so that 0.72727273 is displayed as 72.7% .

Resources