Rounding

  • Thread starter Thread starter Craig
  • Start date Start date
C

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!
 
That is not nearest 5%, 87 should round down to 85?

Maybe round up

=CEILING(A1,0.05)

--


Regards,


Peo Sjoblom
 
Thanks! This is what I needed.


Peo Sjoblom said:
That is not nearest 5%, 87 should round down to 85?

Maybe round up

=CEILING(A1,0.05)

--


Regards,


Peo Sjoblom
Click to expand...
 
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.
 
Back
Top