Forum Discussion
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
JWhite91 In it's simplest form that would be in E4:
=C4/(C4+D4)*100and 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% .