2 Replies Latest reply on Jan 21, 2012 5:39 AM by CraigRozelle

    Rounding-up to the next third

    CraigRozelle

      Title

      Rounding-up to the next third

      Post

      I need to round a number to the next highest third. For example:

      1,345.05 -> 1,345.33

      2,745.54 -> 2,745.67

      175.88 -> 176.00

      The "ceiling" function in Filemaker doesn't seem to work the same as it does in Numbers. Any suggestions would be appreciated.