Rounding

[Craig]

Is there a way to round to the nearest 5%. For example if I have a result
of a formula equal to 84% I want to have it rounded up to 85%, and if the
result is 87% I want it rounded up to 90%. Is there a formula to do this?
Thanks for any help!

 

[Peo Sjoblom]

That is not nearest 5%, 87 should round down to 85?

Maybe round up

=CEILING(A1,0.05)

--


Regards,


Peo Sjoblom

 

[Craig]

Thanks! This is what I needed.

That is not nearest 5%, 87 should round down to 85?

Maybe round up

=CEILING(A1,0.05)

--


Regards,


Peo Sjoblom

 

[Mike]

=IF((A1-FLOOR(A1;5))<(CEILING(A1;5)-A1);FLOOR(A1;5);CEILING(A1;5))

Nearest 5.

 

[Peo Sjoblom]

Too much work plus it is not nearest 5%, it is nearest 500%

This is nearest 5%


=ROUND(A1/0.05,0)*0.05
--


Regards,


Peo Sjoblom

=IF((A1-FLOOR(A1;5))<(CEILING(A1;5)-A1);FLOOR(A1;5);CEILING(A1;5))

Nearest 5.