Announcement

Collapse
No announcement yet.

Rounding Number In Formula To Remove Decimal

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Rounding Number In Formula To Remove Decimal

    My formula is not rounding properly. Cells I4, J4 and K4 all filter from the results of cell I3 divided by 3. (e.g. 10/3 = 3.333) I was able to remove the decimals in cells I1:K3, but the between formulas (I4:K4) keeps adding the decimal back, therefore this results in errors to my chart.

    Any suggestions to correct this???
    Attached Files

  • #2
    Re: Rounding Number In Formula To Remove Decimal

    you can always add
    Code:
    =int(your code + 0.5)
    Eternity is a terrible thought. I mean, where's it going to end??

    Comment


    • #3
      Re: Rounding Number In Formula To Remove Decimal

      Thanks, Fengore

      I found the solution to the problem after making another post, I saw someone else had a similar question.

      The answer was for me to round down.

      =ROUNDDOWN((I3/3),0)

      Comment


      • #4
        Re: Rounding Number In Formula To Remove Decimal

        Thanks, Fengore

        I found the solution to the problem after making another post, I saw someone else had a similar question.

        The answer was for me to round down.

        =ROUNDDOWN((I3/3),0)

        Comment


        • #5
          Re: Rounding Number In Formula To Remove Decimal

          That works too.
          Eternity is a terrible thought. I mean, where's it going to end??

          Comment

          Working...
          X