How do i round up to the nearest 2nd decimal place?

  • wyong
    Asked on November 29, 2016 at 9:51 PM

    Hi there,

     

    I need to do some rounding up of numbers to the nearest 2nd decimal place.

    Example $2.51111111 will round up to $2.52.

    I've tried using the CEIL function but it round up to the nearest whole number.

     

    Thanks

     

  • BJoanna
    Replied on November 30, 2016 at 2:52 AM

    Are you performing calculation inside of your form and you want to round your calculation to 2 decimal places?

    To achieve this you need to set your calculation field to show 2 decimal places in result. 

    How do i round up to the nearest 2nd decimal place? Image 1 Screenshot 20

    This will round up to closest number. For example 2.51111111 will be rounded to 2.51.

    Ceil math function will always round numbers to whole number.

    Is far as I know it is not possible to round them up to nearest 2nd decimal place.

     

    Feel free to contact us if you have any other questions.