Round Function

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.
 
J

JE McGimpsey

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.
 
Top