I have 2 formulas that do what i need them to do separately
=IF(COUNTIF(C3:C20, "Critical") = COUNTA(C3:C20), 0, IF(OR(COUNTIF(C3:C20, "N/A") > 0, COUNTIF(C3:C20, "") > 0), 0.79, 0.79 - (COUNTIF(C3:C20, "Critical") - 1) * 0.0465))
=IF(COUNTIF(C3:C20, "Critical") = COUNTA(C3:C20), 0...