| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Behaviour of VBA ROUND function
Hi all,
I have a question of dealing with VBA ROUND function, the question is that it doesn't do the rounding consistently. For example: ROUND(100.5) - 100 ROUND(100.6) - 101 ROUND(100.55,1) - 100.6 Why is that? Is it a bug? Please advise. Frederick Chow Hong Kong. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round Function | Excel Worksheet Functions | |||
| Round function | Excel Discussion (Misc queries) | |||
| Round up function | Excel Discussion (Misc queries) | |||
| Anomolous behaviour of slope function. | Excel Worksheet Functions | |||
| help with round function | Excel Worksheet Functions | |||
Threaded Mode
