| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round up (ends with...) | Excel Worksheet Functions | |||
| filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
| +(-)ve values ends in Dr(Cr) | Excel Programming | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| Loop never ends | Excel Programming | |||
Hybrid Mode
