View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How to round of the value with ends zero(0)

give this a try...

=ROUND(A1, -1)
--
HTH...

Jim Thomlinson


"P Vasanth Kumar" wrote:

Hi.....

Pls help me. In cell values ends with 0 for ex:

now c1 cell value is 47 that value want to change 50......

Pls reply me.....

Thx n rgrds........

Vasanth