round to nearest quarter cent

[slybitz]

Is there an easy way to get the last two decimal places to round to the nearest quarter cent if I have a given number that is 4 decimal places? So for example if I have the # 40.1234 it would round to 40.1225, or if I have the # 40.1255 it would round to 40.1250, or I have the # 40.1988 it would round to 40.2000.

Thanks for the help!

 

[gmmastros]

Multiply by 4
Round to 2 decimal places
divide by 4

round(40.1234 * 4,2) / 4

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[slybitz]

Just what I needed. Thanks for your help!