COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### How to calculate rounding on 5 cents

• Follow

```Hi,

In filemaker we like to round amounts like 12.42 to 12.40. This is done
in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3
and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.

So

12.41=12.40
12.42=12.40
12.43=12.45
12.44=12.45
12.46=12.45
12.47=12.45
12.48=12.50
12.49=12.50

Is someone able to help me in making a calculation for this?

Thanks

```
 0

```"Rob" <rob@home.nu> wrote in message
> Hi,
>
> In filemaker we like to round amounts like 12.42 to 12.40. This is done
> in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3
> and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.
>
> So
>
> 12.41=12.40
> 12.42=12.40
> 12.43=12.45
> 12.44=12.45
> 12.46=12.45
> 12.47=12.45
> 12.48=12.50
> 12.49=12.50
>
> Is someone able to help me in making a calculation for this?
>
> Thanks
>
>

A simple fix to Lee's solution from yesterday...

= Round( NumberField / 0.05, 0) * 0.05

```
 0

```Rob wrote:
> Hi,
>
> In filemaker we like to round amounts like 12.42 to 12.40. This is done
> in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3
> and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.
>
> Is someone able to help me in making a calculation for this?

Multiply the field by 20, round it to nearest whole number, then divide
by 20.

e.g. (from memory, I forget if it is round() or truncate(), don't have

RoundedField = Truncate(amountField * 20) / 20
```
 0

2 Replies
862 Views

Similiar Articles:

7/23/2012 4:07:19 PM