| Here's a question for you excel gamers...
I'm working on an excel spreadsheet for personal purposes. Part of the spreadsheet involves calculating the bonuses derived from character/creature attributes. For attributes 10 and above, I'm using the following formula:
=roundup((A1-10)/2,0)
By itself this is working quite well. For a value of 7 or 6, for example, it returns -2. For attributes 10 and greater, I use the following formula:
=rounddown((A1-10)/2,0)
This also works out well when used by itself. For values of 12 and 13, for example, it returns 1. But when I combine them with an if statement as follows:
=if(A1<10,roundup((A1-10)/2,0),rounddown((A1-10)/2,0))
it does not return the proper values, instead acting as if I had only used =rounddown((A1-10)/2,0) as my formula. Using this, it always returns a 0 for a value of 9, -1 for values of 8 and 7, -2 for 6 and 5, and so on.
Do any of you see flaws in the latter formula? |

schlakephasmaphobic*Slaps head*

Occam's Razor is now slicing my pride...

adamdrayThe easiest way to compute ability score bonuses in Excel is: =EVEN(A1-1)/2-5 (assuming A1 contains the ability score).

phasmaphobicusing =INT(A1/2-5) works perfectly

phasmaphobicthe_elephant=+FLOOR(E2/2,1)-5

for the bonus.