I am making up a character sheet for an online Dungeons and Dragons game, and I am just having alittle trouble getting one of
the equations on my sheet to work out.
For those of you who are not familiar, the 'Base attack' statistic
determines martial prowess, and it increases faster with some classes faster than others.
Fighters and their ilk
get one point of BA every level including first
Clerics get three quarters of a point every level including first, which rounds down to 0 at first level
Mages get one half of a point every level, which would round down to 0 at first level.
Now on my sheet, the
equations I am using are not working as they are taking the three quarter and one half points the other classes might get and
counting them as a whole point.
I also have to contend with combining up to three different base attack totals on
one sheet due to charecters being allowed to enter different classes with different BA scores.
My equation is
Where B4, C4 and D4 are the cells that contain the number that shows what the BA
progression is for the given class. And b5, c5 and d5 represent how many levels the character has in that class
represents the full progression, and B5 equals the level, so if B5 was two, the first part would equate to one point of BA.
That part works out fine so far. But where it gets to the C4*C5 parts, with c4 being .75. For some reason it is adding that
all up as a whole point as well. D4* D5 is doing the same.
B4, C4 and D4 are formatted to number and displaying
ftwo digits after the decimal to allow for .75 to fit
B5, C5 and D5 are formatted to number and displaying zero digits after the decimal
The cell that
=(B4*B5)+(C4*C5)+(D4*D5) is in is also formatted to number and displaying zero digits after the decimal.
it's really a simple correction that i'm missing, but any help would be appreciated.