AnsweredAssumed Answered

Rounding-up to the next third

Question asked by CraigRozelle on Jan 20, 2012
Latest reply on Jan 21, 2012 by CraigRozelle


Rounding-up to the next third


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.