Happy New Year Everyone,
I am trying to use an IF Statement here; however keep getting Syntax Error. Appreciate if anyone could kindly assist. Thank you
=IF((K7)>=60,(K7)<80),0.02, IF(AND((K7)>=80,(K7)<100),0.035, IF(AND((K7)>=100,(K7)>=120),0.0425,0.05)))
If the result is >=60%, then it...