How can I round in quarter points?

[frumious]

I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00 for
example

[Biff]

Hi!

Try this:

=ROUND(A1/0.25,0)*0.25

Biff

"frumious" <[email protected]> wrote in message
news:[email protected]...
>I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
>for
> example

[macropod]

Or
=ROUND(A1*4,0)/4

Cheers
--
macropod
[MVP - Microsoft Word]


"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try this:
>
> =ROUND(A1/0.25,0)*0.25
>
> Biff
>
> "frumious" <[email protected]> wrote in message
> news:[email protected]...
> >I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
> >for
> > example
>
>

[David Biddulph]

"frumious" <[email protected]> wrote in message
news:[email protected]...
>I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
>for
> example

=MROUND(A1,0.25)
--
David Biddulph

[[email protected]]

Hello,

=INT(F3*4+0.5)/4

if you do not like (or you do not know or you do not have) ROUND/MROUND
:-)

Regards,
Bernd