Issue with a formula
The following formula doesn’t work. May I have some support?
Thank you
JF Lahou
=IF(OR(AND(SUM(B30;B38;B46;B54;B62;B70;B78;B86;B94)>=120;SUM(B30;B38;B46;B54;B62;B70;B78;B86;
B94<=150;);33000;2;”min teaching hours not reached”);OR(SUM(B30;B38;B46;B54;B62;B70;B78;B86;B94)>150;35000;2;”min teaching hours not reached”)))
The following formula doesn’t work. May I have some support?Thank youJF Lahou =IF(OR(AND(SUM(B30;B38;B46;B54;B62;B70;B78;B86;B94)>=120;SUM(B30;B38;B46;B54;B62;B70;B78;B86;B94<=150;);33000;2;”min teaching hours not reached”);OR(SUM(B30;B38;B46;B54;B62;B70;B78;B86;B94)>150;35000;2;”min teaching hours not reached”))) Read More