Rounding (to nearest half percentage point)

=Round function (or some other derivative of it)

If the value is 85.29% and my desired result is 85.50% (or to round 85.21% to 85.00%) , what is the right formula?

=round(A1, -3) results in 85.30% - not what I'm looking for.

Working with a number formatted as a percentage may be complicating things?

Thanks.

Try:
=MROUND(A1,0.0005)
Or
=CEILING(A1,0.0005)
Or
=ROUNDUP(A1,3)
and Format cells / Percentage / Decimal places = 2

Thank you both!