| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round up to nearest multiple of 5
I am writing a macro and I need it to take a number and round it up to
the nearest multiple of 5. For example: If the number is 74 the macro would change it to 75 If the number is 65.7 the macro would change it to 70 etc. Can someone show me how to do this? Thanks, Kyle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
| How do I round numbers to the nearest multiple of 10 or 5 in the same cell? | Excel Worksheet Functions | |||
| Round Down to the nearest multiple | Excel Discussion (Misc queries) | |||
| Round to nearest multiple | Excel Discussion (Misc queries) | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
Threaded Mode
