Function ROUND() not working with brackets

  • Sakudo

    (@sakudo)


    1 week, 5 days ago

    Hi,

    thanks for the plugin.

    I have to round an expression and I have observed that the ROUND() function does not like additional brackets and gives an error SyntaxError: missing ) in parenthetical

    Say, I want to round (var1+1)/(var2+1), where var1 and var2are numbers.
    I would expect the code to be ROUND((var1+1)/(var2+1)). But it does not work, giving the above error message.

    ((var1+1)/(var2+1)) does work and gives the (unrounded) result.

    Similarly ((var-1.234)) or ((var-1.234)/2) or round(var-1.234/2) work (with different results ofc), but round((var-1.234)/2) does not.

    Any help greatly appreciated. Cheers.

    • This topic was modified 1 week, 5 days ago by Sakudo. Reason: typo

You must be logged in to reply to this topic.