1. Forum
  2. Usenet
  3. COMP.DATABASES.FILEMAKER

  • How to calculate rounding on 5 cents

    From bucko31416@gmail.com@21:1/5 to Rob on Tue Jul 7 22:39:39 2020
    On Thursday, 2 September 2004 05:00:13 UTC+10, 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.

    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to bucko31416@gmail.com on Wed Jul 8 08:17:04 2020
    On Tue, 7 Jul 2020 22:39:39 -0700 (PDT), bucko31416@gmail.com wrote:
    On Thursday, 2 September 2004 05:00:13 UTC+10, 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.

    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?

    You quote a question from 2004?

    round.5 =
    case(
    country = "BE",
    round(number*2,1)/2,
    number)

    Make sure to display numbers with two digits, otherwise the last 0 will
    not be displayed.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)