Boards›[ARCHIVED] Miscellaneous

How to calculate KDA

Drizzt Strife·9/8/2015, 3:17:15 AM·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 X9/8/2015, 3:26:04 AM1 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

50000000000000009/8/2015, 3:29:15 AM1 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)