Talk:Damage Calculator/@comment-15871805-20130901233514/@comment-11753608-20130902130411

Found it.

Do MAX(ModA, ModB, ModC, ModD) for the highest one, then subsequent Mod values in the equation could then use LARGE(range, value order). So, say I want the second largest value - I type LARGE(range, 2) and so on. One equation, no if checks, just plug that in where you need the second, third, and forth largest value.

Since the it only does ranges and not a bunch of random cells, we may need to hide a second set of the modded elemental damages that are all right next to one another without any junk in between somewhere on the sheet. Or maybe it is time to create a 4th sheet for random calcs like this so they are easier for us to find later. Seems like there are a lot of them now.