Reply to thread

Message

<blockquote data-quote="PrecociousApprentice" data-source="post: 4265523" data-attributes="member: 61449">So here is my contribution.If you change the first Misc box in the fort, reflex, and will defenses to race you could add these lines to that cell.Fort-&nbsp; =IF(B12=&quot;Human&quot;,1,0)Reflex-&nbsp; =IF(B12=&quot;Human&quot;,1,0)Will-&nbsp; =IF(OR(B12=&quot;Human&quot;,B12=&quot;Eladrin&quot;),1,0)This will autocalculate the effect of race on defenses.If you add these lines to the Class box for each defense you can autocalculate for each classes effect on defenses.Fort-&nbsp; =IF(AO9=&quot;Fighter&quot;,2,IF(NOT(OR(AO9=&quot;Cleric&quot;,AO9=&quot;Warlock&quot;,AO9=&quot;Wizard&quot;)),1,0))Reflex-&nbsp; =IF(AO9=&quot;Rogue&quot;,2,IF(NOT(OR(AO9=&quot;Fighter&quot;,AO9=&quot;Cleric&quot;,AO9=&quot;Warlord&quot;, AO9=&quot;Wizard&quot;)),1,0))Will- =IF(OR(AO9=&quot;Wizard&quot;,AO9=&quot;Cleric&quot;),2,IF(NOT(OR(AO9=&quot;Fighter&quot;,AO9=&quot;Rogue&quot;,AO9=&quot;Ranger&quot;)),1,0))These will just calculate for you if you enter your race and class in the appropriate boxes. I have attached a mod of your excel sheet to test if you like.</blockquote>

[QUOTE="PrecociousApprentice, post: 4265523, member: 61449"] So here is my contribution. If you change the first Misc box in the fort, reflex, and will defenses to race you could add these lines to that cell. Fort- =IF(B12="Human",1,0) Reflex- =IF(B12="Human",1,0) Will- =IF(OR(B12="Human",B12="Eladrin"),1,0) This will autocalculate the effect of race on defenses. If you add these lines to the Class box for each defense you can autocalculate for each classes effect on defenses. Fort- =IF(AO9="Fighter",2,IF(NOT(OR(AO9="Cleric",AO9="Warlock",AO9="Wizard")),1,0)) Reflex- =IF(AO9="Rogue",2,IF(NOT(OR(AO9="Fighter",AO9="Cleric",AO9="Warlord", AO9="Wizard")),1,0)) Will- =IF(OR(AO9="Wizard",AO9="Cleric"),2,IF(NOT(OR(AO9="Fighter",AO9="Rogue",AO9="Ranger")),1,0)) These will just calculate for you if you enter your race and class in the appropriate boxes. I have attached a mod of your excel sheet to test if you like. [/QUOTE]

Verification