Hi,
I would like to be able to round off a number to the nearest increment of 25 for example $12.10 would equal $12.00 or $12.13 would change to $12.25. Any help would be appreciated.
Thanks
Gary
Hi,
I would like to be able to round off a number to the nearest increment of 25 for example $12.10 would equal $12.00 or $12.13 would change to $12.25. Any help would be appreciated.
Thanks
Gary
=ROUND(A1/25,2)*25
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
=ROUND(A1*4,0)/4
Thanks for the help guys. Mdmackillop's version was the one I tried first and it worked great.
Gary