Looking for excel formula to calculate win%.

Copper Contributor
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
1 Reply

@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% .