Skip to Main Content

Share your product feedback

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
      Drop here to upload
    • 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.