Also, Excel won't complain about an odd calculation in the middle of the others.įirst, thanks for your pointing out the four wrong calculations. In fact, the above calculation column could be applied to all of column J in the Characteristics section, allowing GM's to create fraction costs for other characteristics, specific to his campaign. So if the character wants to have less than the starting number of Characteristic points, the subtraction will be negative, and the rounding will be to a negative integer.īecause of this, the calculations for J23 and J25 need to change: The SIGN function will return a positive 1, if the parameter is positive, a 0 if the parameter is 0, and a -1 if the parameter is negative. ![]() BUT, if the player is selling back points, the result of the division will be negative, and you can't round to a positive integer. We always want to round to an integer (a whole number) in the case of costs.
0 Comments
Leave a Reply. |