Skip to content

How can we improve Proton Drive?

← Proton Drive

Fix roundup to work correctly in Proton Sheets

If you have a sheet that has the formula "=14/7" it will show the correct answer of 2. However if you perform a roundup such as "=roundup(14/7,2)" it will show the incorrect answer of 2.01. This means that doing the formula =roundup(14/7,0) to get the number of weeks left gives the incorrect answer of 3.

This makes roundup functionally useless as the output is not accurate when dealing with any calculations.

3 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Melissa Hadfield shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • BreizhTiger commented  ·   ·  Report

    ROUNDUP(1.9) yields 2 : OK
    ROUNDUP(2) yields 3 : WRONG ! Should be 2
    ROUNDUP(2.1) yields 3 : OK

    Thank you for fixing ROUNDUP, indeed useless in the current state.

Proton Drive: Changes to existing features

Categories