1 Reply Latest reply on Jun 25, 2015 8:17 AM by TSGal

# how to round up numbers (not to 0,5)

### Summary

how to round up numbers (not to 0,5)

### Product

FileMaker Pro

FM Pro 14

Windows 7

### Description of the issue

FileMaker "rounding" function is set to round up numbers to 0,5
This means that 110,221 is rounded up to 110,22 and 110,226 is rounded up to 110,23.
I want 110,221 to be rounded up to 110,23
I'll appreciate your help very much!

### Steps to reproduce the problem

I have tried to use the "Arrotondamento" function (I have the Italian version and guess it it correspond to a "round" function in English)
but of course it does not work.

• ###### 1. Re: how to round up numbers (not to 0,5)

Rossella Spangaro:

The Ceiling function will round a number up to the next integer.  Therefore, assuming your field is named "Amount", the formula would be:

Ceiling ( Amount * 100 ) / 100

Using your example of Amount = 110,221
Ceiling ( 110,221 * 100 ) / 100
Ceiling ( 11022,1 ) / 100
11023 / 100
110,23

Let me know if you need additional clarification.

TSGal
FileMaker, Inc.