Conditional test

[Abraham Zacharia]

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%

 

[Max]

Try in J2:
=IF(A2="","",IF(A2="x",SUM(B2:H2)*40%,SUM(B2:H2)*42.5%))

Success? Click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik