I am trying to round up to the nearest 25 cents

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

Try

=CEILING(A1, 0.25)

In article <[email protected]>,
sypher <[email protected]> wrote:

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

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

"sypher" <[email protected]> wrote in message
news:[email protected]...
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
>