Problem on what to use for formula.

[timpaks]

A B C D E F G

Threads QA'd​	INCORRECT CONTEXT FORMATTING CRITICAL ERROR <tbody> </tbody>	Total Overall Weighted Score <tbody> </tbody>
10​	3.5 0 1 0 <tbody> </tbody>	3.5 65.00% <tbody> </tbody>
10​	3 0 0 1 <tbody> </tbody>	4 60.00% <tbody> </tbody>
10​	0 0 0 1 <tbody> </tbody>	1 90.00% <tbody> </tbody>

<tbody>
</tbody>

• I want to make the Overall Score = 0% if Critical error is equal to 1 or more . can anyone teach me the formula to it or can anyone suggest another way to get my desired result.
• also in row 2 you can see that incorrect is =3 but it have critical error equals to 1, so i also want the Overall Weighted Score to be 0%.

my current formula on firt tab. (ill just include the first row for reference):

Total

Overall Weighted Score

<tbody>
</tbody>

=sum(B1:E1)

=if(A1=0,0,1-(F1/A1))

<tbody>
</tbody>

 

[Mackers]

Hi

In general:

=IF(CellContainingCriticalScore>=1, 0, YourNormalWeightedScoreFormula)

Hope that makes sense

Mackers