Round Function

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

 

[Frank Kabel]

Hi Rohit
try
=ROUND(C5*2,1)/2
HTH
Frank

 

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