Forum Discussion

JFLahou's avatar
JFLahou
Copper Contributor
May 17, 2024

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")))

Formulas and Functions

3 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    May 17, 2024

    JFLahou 

    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.

    • JFLahou's avatar
      JFLahou
      Copper Contributor
      May 17, 2024

      SergeiBaklan 

      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

Resources