Round Function

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hi All,

How can I change .93 to .95 or 2.97 or 3.00. I have a list
of 1000 entries like this..

Can somebody Help.
 
that doesn't round 2.97 to 3.00 (I'm assuming the second "or" should be
"to"), but rather to 2.95.

Without more examples, it's hard to tell what the OP wants, but if it's
desired to always round *up* to the nearest 0.05, then

=CEILING(C5,0.05)

will work.
 
Back
Top