Excel decimal rounding

Question

What is excel's function of rounding the last decimal point?

9.23 => 9.25
10.26 => 10.30
9.25 => 9.25

+1

tony May 14 '09 at 5:37 am

2 answers

Matt hanson · Answer 1 · 2009-05-14T05:58:42+0000

Use the CEILING function for rounding. Use the FLOOR function for rounding.

=CEILING(9.23,0.05)

Sam ax · Answer 2 · 2009-05-14T05:39:32+0000

Check the function ROUND

.