2 Replies Latest reply on Nov 18, 2016 1:46 PM by Rekha Kesavan

    Find sum of remainders and add to last row

    Aubrey Scarborough

      Hello,

       

      I need some help with a calculation where I need to add the remainders of some categories to the value of another category. Like in the table below, I need to round down a 12% allocation for Type A, B, And C. Then add the sum of those remainders to the allocation of Type D. Basically, I'm trying to end up with the numbers in my "Final Calc" column.

       

      CatergoryCount12% of CountRemainder (Found w/Modulo)Final Calc
      Type A202.40.42
      Type B354.20.24
      Type C151.80.81
      Type D303.60.6

      5

      (3.6+0.4+0.2+0.8)

       

      I've tried making some If/Then statements, but having a hard time. Any suggestions?

       

      Thanks!

      Aubrey