PDA

View Full Version : Solved: ROUND OFF TO NEAREST INCREMENT IN 25



GaryB
04-10-2007, 10:20 AM
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

mdmackillop
04-10-2007, 10:27 AM
=ROUND(A1/25,2)*25

xld
04-10-2007, 10:50 AM
=ROUND(A1*4,0)/4

GaryB
04-10-2007, 10:57 AM
Thanks for the help guys. Mdmackillop's version was the one I tried first and it worked great.

Gary