Solved: ROUND OFF TO NEAREST INCREMENT IN 25 [Archive]

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

Bob Phillips

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