Hi experts. I am trying to model the following table Rank Bonus 0 -25 1 - 10 +5 per rank 11 - 20 +3 per rank 21 - 30 +2 per rank 31+ +1 per rank Currently it looks like this: <input type="text" name="attr_animalhandling1rankbonus" title="animalhandling1rankbonus (Skill Rank Bonus)" value="-25 + ({@{animalhandling1ranks}, {1} }kl1 * 25) + ({@{animalhandling1ranks}, {10} }kl1 * 5) + ({{@{animalhandling1ranks} - 10} , {0} } kh1}, {10} }kl1 * 3) + ({{@{animalhandling1ranks} - 20} , {0} } kh1}, {10} }kl1 * 2) + ({@{animalhandling1ranks} - 30} , {0} }kh1 * 1)"/> Here is the sheet calculation bit value="-25 + ({@{animalhandling1ranks}, {1} }kl1 * 25) + ({@{animalhandling1ranks}, {10} }kl1 * 5) + ({{@{animalhandling1ranks} - 10} , {0} } kh1}, {10} }kl1 * 3) + ({{@{animalhandling1ranks} - 20} , {0} } kh1}, {10} }kl1 * 2) + ({@{animalhandling1ranks} - 30} , {0} }kh1 * 1) But I can't get it to parse and return a number. Anyone see where I am erroring out? Thanks.
