Talk:Damage Calculator/@comment-11753608-20130824172807/@comment-11753608-20130824175740

Help........

=IF(Calculator!B4="Melee", Calculator!M11, IF(VLOOKUP(B3, Weapons!1:1048576, 24, FALSE)>0, (Calculator!M17/((((ROUNDDOWN(Calculator!M17/VLOOKUP(B3, Weapons!1:1048576, 24, FALSE), 0)*(VLOOKUP(B3, Weapons!1:1048576, 24, FALSE)-1))+(MAX(MOD(Calculator!M17, VLOOKUP(B3, Weapons!1:1048576, 24, FALSE))-1,0)))*VLOOKUP(B3, Weapons!1:1048576, 25, FALSE))+Calculator!M14+ROUNDUP(Calculator!M17/VLOOKUP(B3, Weapons!1:1048576, 24, FALSE), 0)/Calculator!M11)), ((IF(OR(Calculator!B4="Pistol-Continuous", Calculator!B4="Rifle-Continuous"), Calculator!M17/10, CalculatorM17))/(Calculator!M14+(IF(OR(Calculator!B4="Pistol-Continuous", Calculator!B4="Rifle-Continuous"), Calculator!M17/10, CalculatorM17))/Calculator!M11))))

Anything that isn't a melee weapon is returning a #N/A error.