Developing damage roll formulas for my new top-down rpg. If anyone is curious this seems like a very effective statistical outcome. You can alter the distribution ranges by changing the sides on a die and how many rolls. The hard part is figuring out how to implement player stats into the formula. I'm thinking attack rating can effect the sides of one die per point.?

Sorry there was a logical error and it wasn't checking R2. Now it's fixed, this illustrates the importance of debugging through outputs!

You can condense the part where you get rid of the lowest value to a single line by using the MIN function, which returns the lowest value out of two values you send to it. DMG=R1+R2+R3-MIN(R1,MIN(R2,R3)) As a side note, you can also use the MIN function to find the lowest value in an array.

Oh that's helpful. One thing, what's with the syntax, why need MIN inside parens like that? Thanks Oscar.

Nevermind I see, it can only compare 2 values!