Skip to main content

Hi folks, I have a problem with the Round() function. I have a formula to display two percentages as text;

ROUND({Australian Shares % of Portfolio},4)*100&"% vs target “&ROUND({Australian Shares Target},3)*100&”%"

The output is fine in about 80% of cases but occasionally I get this;

28.999999999999996% vs target 35%

I have tried formatting the original formulas with Round and formatting options but have not been able to stop this happening. Any thoughts on what I could do?

Thanks,

Jonathan

Try multiplying before you round, so that rounding is the last mathematical operation.


CONCATENATE(

  ROUND({Australian Shares % of Portfolio} * 100, 2),

  "% vs target ",

  ROUND({Australian Shares Target} * 100, 1),

  "%"

)

Reply


Terms & Conditions