Forum Discussion
JFLahou
May 17, 2024Copper Contributor
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...
SergeiBaklan
May 17, 2024Diamond Contributor
You formula is
=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")
)
)
Sure it doesn't work, but it's unclear from the above what you'd like to calculate.
- JFLahouMay 17, 2024Copper Contributor
Hello Sergei,
Thanks for your quick reaction.
I realize it is not working, you're right! I come back later if necessary.
All the best,
Jean-François
- SergeiBaklanMay 17, 2024Diamond Contributor
You may explain in plain English what formula shall do, we will try to help.