A ajeuck Jul 3, 2008 #1 How do I round a dollar amount to the nearest .25 i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....
How do I round a dollar amount to the nearest .25 i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....
T T. Valko Jul 3, 2008 #3 Try one of these: Requires the Analysis ToolPak add-in be installed for Excel versions prior to Excel 2007: =MROUND(A1,0.25) This one will work in any version: =ROUND(A1/0.25,0)*0.25
Try one of these: Requires the Analysis ToolPak add-in be installed for Excel versions prior to Excel 2007: =MROUND(A1,0.25) This one will work in any version: =ROUND(A1/0.25,0)*0.25
A ajeuck Jul 3, 2008 #4 Fabulous!!! Thank you! Is there a way to set parameters? i.e if less than .12 round down more than .12 round up?
Fabulous!!! Thank you! Is there a way to set parameters? i.e if less than .12 round down more than .12 round up?
