I am trying to use the if condition to try and achieve the following outcome
from a list as a drop down box.

1. If the value in cell A2 = x (this is a text input an if true)
then
value in cell J2 = Sum(B2:H2)*40%
else
value in cell J2 = Sum(B2:H2)*42.5%