{{
`${userDetail.user.displayName}${userDetail.user.cachedBungieGlobalDisplayNameCode ? `#${standardizeBungieGlobalCode(userDetail.user.cachedBungieGlobalDisplayNameCode)}` : ""}`}}
{{getUserClans()}}
11/23/2015 3:29:23 PM
3
The formula to calculate K/D ratio
I'm working in excel and I'm trying to properly make a K/D ration formula I currently have Kills/Deaths which works 90% of the time but I'm having an issue where if the deaths are 0 the formula isn't working does anyone know of a consistent way to formulate K/D ratio?
English
#Help
-
1 ReplyThank's guys I figured it out. The solution I came up with is =IF([@Deaths]<=0,[@Kills],[@Kills]/[@Deaths])
-
5 RepliesEdited by Kell of Kellogs: 11/23/2015 3:49:45 PMIf deaths = 0, set the kd value = the number of kills, regardless of deaths That would be my best guess, as for the correct input of this equation into excel... I'm not sure there
-
5 RepliesYou can't divide by 0 (as in Kills/0 if deaths = 0). Just add a clause that sets the K/D to the value of Kills if Deaths is 0 otherwise set it to Kills/Deaths.
