Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom round function
I'm writing a function to change the last integer in a numeric value t
either a 5 or a 9-(replicating a Peachtree function). The Select case functions is clearly an option, but how do I get th function to focus on the last integer ? The * doesn't work- example: Change 1442 to 1445 1327.55 to 1329 thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round to thousands via custom format? | Excel Worksheet Functions | |||
Round Len Function Help | Excel Worksheet Functions | |||
Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
Custom formats to round numbers such as 16,465,123 to 16,500,000 | Excel Discussion (Misc queries) | |||
Custom formats to round numbers such as 465,123 to 465,000 | Excel Worksheet Functions |