Skip to main content

Problems with rounding

  • September 28, 2021
  • 1 reply
  • 21 views
J

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

1 reply

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • September 28, 2021

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),
  "%"
)
J
Justin_Barrett
F
Terms & ConditionsAccessibility statement