How to calculate KDA

Drizzt Strife·Sep 8, 2015·1 votes·934 views

I understand the current formula: (Kills + Assists) / (Deaths).

I'm creating a spreadsheet for my team, with statistical values for each practice game/ranked game we do. As you can see my obvious problem here when someone doesn't die in a game I get a Divide by zero error. I know when you're calculating someone's KDA you add +1 to the death counter if they didn't die, but doesn't remain true when they do die at least once. So my question is really pertaining to how to create a formula to accurately calculate this on a Google Docs (spreadsheet). Please do not tell me to manually calculate 0 death's differently, because that isn't efficient, and I wouldn't be using spreadsheets if I wanted to manually tack in formulas over and over again.

Any help towards this will be appreciated.

Cheers, Drizzt Strife

6 Comments

Archon XSep 8, 20151 votes

do a raw deaths divided by zero equals modified deaths, with the higher value taking precedence.

So 0 deaths: 0/0 = 1, 1 death

1 death: 1/0 = 0, 1 > 0 = 1 death

https://productforums.google.com/forum/#!topic/docs/QYbLk9o7gQI

Drizzt StrifeSep 8, 20151 votes

[{quoted}](name=Archon X,realm=NA,application-id=cIfEodbz,discussion-id=LhtVKo4P,comment-id=0000,timestamp=2015-09-08T03:26:04.997+0000)

do a raw deaths divided by zero equals modified deaths, with the higher value taking precedence.

So 0 deaths: 0/0 = 1, 1 death

1 death: 1/0 = 0, 1 > 0 = 1 death

https://productforums.google.com/forum/#!topic/docs/QYbLk9o7gQI

Thank you so much :]

5000000000000000Sep 8, 20151 votes

There's a way to use if-else gate on excel, and I'm assuming the same for Google spreadsheet. I forgot the exact formula, but it would look something like =if(death=0, kills+assists, (kills+assists)/deaths)

Drizzt StrifeSep 8, 20151 votes

{quoted}

There's a way to use if-else gate on excel, and I'm assuming the same for Google spreadsheet. I forgot the exact formula, but it would look something like =if(death=0, kills+assists, (kills+assists)/deaths)

Thank you so much :] I think I'll attempt this first, because I love if then statements. (programming ftw)

Drizzt StrifeSep 8, 20151 votes

{quoted}

There's a way to use if-else gate on excel, and I'm assuming the same for Google spreadsheet. I forgot the exact formula, but it would look something like =if(death=0, kills+assists, (kills+assists)/deaths)

Sorry for spamming you, but the exact formula worked (pretty much word for word).

For anyone else interested:

If(Statement, if statement value is true, if statement value is false)

KDA: =if(Deaths = 0, Kills + Assists, (Kills + Assists) / Deaths)

statement: Deaths = 0 if true: Kills + Assists if false: (Kills + Assists) / Deaths

5000000000000000Sep 8, 20151 votes

Ah, good to know! Glad I could help :)