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

### How to calculate rounding on 5 cents

• Email
• 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
Reply Rob 9/1/2004 7:00:13 PM

See related articles to this posting

```"Rob" <rob@home.nu> wrote in message
news:41361c4e\$0\$148\$e4fe514c@dreader18.news.xs4all.nl...
> 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
Reply Glenn 9/1/2004 7:06:57 PM

```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
access to FM right now)

RoundedField = Truncate(amountField * 20) / 20
```
 0
Reply Kevin 9/1/2004 7:19:25 PM

2 Replies
1094 Views

Similar Articles

12/7/2013 2:52:22 AM
page loaded in 24386 ms. (0)

 Reply:

Similar Artilces: