Skip to Main Content
Status Future consideration
Created by Guest
Created on Jul 29, 2020

Worksheet formula for rounding up

Having a formula in the custom worksheet for rounding values up, regardless of decimal values would be very useful and beneficial. Eg: 14.2 -> 15

  • Attach files
  • Guest
    Reply
    |
    Jul 31, 2020

    Thanks Nathaniel for the suggestion. That was something I had tried however, when a number is, for example 14.2 it rounds to 14. So it is not exactly what I am looking for.

  • Admin
    Nathaniel Collum
    Reply
    |
    Jul 31, 2020

    Thanks for sharing this idea. In the meantime, you may choose to change how numbers are formatted in your worksheet. In the worksheet configuration screen, you can click the type icon and select "No decimal" to have it automatically round up or down.

    It sounds like you need something that always rounds up, but maybe this would help with some of your cases.