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

try =MROUND(A1,10) if 47 is in cell A1
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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