4 Replies Latest reply: May 24, 2017 4:28 AM by Sunny Talwar RSS

    IF statements

    Jonathan Studsrød

      Hi,

       

      I have the following problem:

       

      I get 45$ in provision for the first 1250 sales of the year, and 5$ for everything above that. How do I calculate this per month?

       

      It should be.

       

      jan. 169 sales, provision= 169*45=7 605

      feb. 1379 sales, provision= 1081*45 + 298*5 = 50 135

      mar. 772 sales, provision= 772*5= 38 600

       

      My problem is february, when I Reach 1250 sales, and only get 5$ for sale nr. 1251..

       

      Jonathan