10 Replies Latest reply on Mar 13, 2018 9:38 AM by gkaiseril

    Calculations - Rounding problems

    Level 1
      I'm trying to setup sales tax forms that do all of the math for you after you enter in the key numbers. It works great except one little bug. The forms require all amounts to be rounded to the nearest dollar. No problem there. It's the overall total that's the problem. My form has two columns. In column total in (A) has the amount of 459 and the total in column (b) has 1,331. However the total of the two columns is 1,791. I know it because of the rounding in some of the previous cells. How do you get the last cell to use the rounded numbers instead of using the actual numbers in it's calculation? Thanks