Perhaps you missed the bit where I said:
"MROUND
Look it up in Excel help." ?
--
David Biddulph

"se7098" wrote in message
...
this is returning an error: #NAME?

"Sean Timmons" wrote:

Just to clarify, it would be

=MROUND(D1/52,.25)

and

=MROUND(D1/12,.25)

"David Biddulph" wrote:

MROUND
Look it up in Excel help.

....