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:
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:
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:
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?