Getting next highest Number

[china1383]

Hello Experts,

I have excel column which contains numbers. Now my requirement is if I select specific number in cell, then the next highest number with precision of 10 should get displayed in immediate cell.

E.g If my excel row contains number as :
122
125
126
127

If I select 125 celll then next highest number with 10 precision i.e 130 should get displayed. If number is 122 then again 130 should get displayed.

Any help in this reagrd is greatly appreciated.

Regards,
Jonathan

 

[SteveO59L]

Have a look at roundup() or ceiling()

 

[Andrew Poulsom]

You can use the CEILING function, eg:

=CEILING(122,10)

returns 130.

 

[china1383]

Thank You Steve and Andrew .... CEILING seems to be working for me

Thanks a lot for your help

Regards,
Jonathan