How to round of the value with ends zero(0)
 

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

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

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