| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounded-off number
Hello all, does anyone know how in VB to make the rounded-off number. If I have in Cell A1 "1", I want "10" If I have in Cell A2 "8", I want "10" If I have in Cell A3 "12", I want "20" If I have in Cell A4 "119", I want "120" If I have in Cell A5 "1015", I want "1020" If I have in Cell A6 "110", I want "110" If I have in Cell A7 "111", I want "110" .... Thanks in advance Herve -- herve ------------------------------------------------------------------------ herve's Profile: http://www.excelforum.com/member.php...o&userid=27314 View this thread: http://www.excelforum.com/showthread...hreadid=481937 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a Rounded number in a LOOKUP command | Excel Discussion (Misc queries) | |||
| how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
| Number are rounded to thousand, but they now do not foot | Excel Discussion (Misc queries) | |||
| marrying a rounded number to concatenation. | New Users to Excel | |||
| showing a rounded number without rounding it | Excel Programming | |||
![herve[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
