formula help

[w123kid]

looking to craete a formula that if Q2 (drop down list 0%, 25%, 50% 100%) has any numerical value (25-50-100%) it doesnt run a calulation and it just dispalys same number (s2) but if not it runs the below cal

help


=IF(Q2>24%,S2,Sum(S2*(SUM(ThroughputFormulas!C28:C31)))

 

[w123kid]

Ah ah runs ok just hadnt the "sum" in the excel sheet

 

[w123kid]

actually it should be a double if

=IF(E4=4 DID, AND,IF=Q2>24%,S2,Sum(S2*(SUM(ThroughputFormulas!C28:C31)))

 

[w123kid]

can anyone verify this?

 

[w123kid]

solved