I am trying to round up to the nearest 25 cents

sypher · Apr 25, 2005

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

JE McGimpsey · Apr 25, 2005

Try

=CEILING(A1, 0.25)

Bob Phillips · Apr 26, 2005

=ROUND(A1*4,0)/4