Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to .05 or .09
How can I round prices to the nearest 0.05 or 0.09?
Eg 1 5.01 to 4.99 Eg 2 4.44 to 4.45 Regards, Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
round up | Excel Worksheet Functions | |||
round up | Excel Discussion (Misc queries) | |||
Round up or down | Excel Discussion (Misc queries) | |||
Round up to 100? | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |