Looking for excel formula to calculate win%.

%3CLINGO-SUB%20id%3D%22lingo-sub-2282106%22%20slang%3D%22en-US%22%3ELooking%20for%20excel%20formula%20to%20calculate%20win%25.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282106%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENew%20to%20excel%20and%20looking%20for%20a%20formula%20to%20basically%20calculate%20win%20%25.%20The%20picture%20is%20how%20my%20current%20W%2FL%20table%20is%20set%20up.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282106%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282152%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20excel%20formula%20to%20calculate%20win%25.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034475%22%20target%3D%22_blank%22%3E%40JWhite91%3C%2FA%3E%26nbsp%3BIn%20it's%20simplest%20form%20that%20would%20be%20in%20E4%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DC4%2F(C4%2BD4)*100%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20copy%20down.%20You%20could%20leave%20out%20the%20%3CSTRONG%3E*100%3C%2FSTRONG%3E%20at%20the%20end%20and%20format%20cells%20in%20E%20as%20a%20percentage%20with%20the%20desired%20number%20of%20decimals%2C%20so%20that%200.72727273%20is%20displayed%20as%2072.7%25%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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% .