The formula I came up with for Excel is:
ROUNDUP((ROUNDUP(A2/3,0)*3)*$B$1,0) where A2 is the total hit points and $B$1 is the fraction (.40,.33,.25,or .16).
Incidentally, there's an error on the line for 10-12 hit points, under the .25 column. That hit location should have 3 hit points, not 2.
Thanks to the people who helped me with the problem!
Guy
- ----------------------------------
Powered by hypermail