Talk:Damage Calculator/@comment-68.57.145.170-20130803075137

I dont know if this was pointed out or fixed, but for the crit dmg for Dread needs to be 200

so something like this

=IF(( B3 ="Kestrel"), IF(( B4 =Calcs!N2), 100, VLOOKUP( B3 ,Weapons!1:1048576,5,FALSE)), IF(( B3 ="Plasma Sword"), IF(( B4 =Calcs!N1), VLOOKUP( B3 ,Weapons!1:1048576,5,FALSE),200),IF(( B3 ="Dread"), IF(( B4 <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;">=Calcs!N1), VLOOKUP( <span style="font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;color:rgb(16,150,24);">B3 <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;">,Weapons!1:1048576,5,FALSE),200), IF(( <span style="font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;color:rgb(221,85,17);">B4 <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;">=Calcs!N1), VLOOKUP( <span style="font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;color:rgb(16,150,24);">B3 <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;">,Weapons!1:1048576,5,FALSE),150))))

<span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;line-height:normal;white-space:pre-wrap;">it does work on my local copy.