How can I round in quarter points?

's Computer Specifications

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

's Computer Specifications

Hi!

Try this:

=ROUND(A1/0.25,0)*0.25

Biff

"frumious" <(E-Mail Removed)> wrote in message
news:F2BCA68C-6675-44C3-8096-(E-Mail Removed)...
>I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
>for
> example

's Computer Specifications

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

Cheers
--
macropod
[MVP - Microsoft Word]

"Biff" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi!
>
> Try this:
>
> =ROUND(A1/0.25,0)*0.25
>
> Biff
>
> "frumious" <(E-Mail Removed)> wrote in message
> news:F2BCA68C-6675-44C3-8096-(E-Mail Removed)...
> >I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
> >for
> > example
>
>

's Computer Specifications

"frumious" <(E-Mail Removed)> wrote in message
news:F2BCA68C-6675-44C3-8096-(E-Mail Removed)...
>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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Round to nearest quarter	TraciAnnNeedsHelp	Microsoft Access	5	9th Mar 2009 08:16 PM
Round to nearest quarter number	Cy	Microsoft Access Queries	1	27th Oct 2008 05:31 AM
How can you round numbers to the nearest quarter (i.e. .63=>.75)	=?Utf-8?B?RU0=?=	Microsoft Excel Worksheet Functions	4	20th Jul 2007 06:07 PM
I want to round Int to quarter	QUESTION-MARK	Microsoft Excel Worksheet Functions	3	8th Jan 2007 07:20 PM
how do I round 3.30 to the nearest quarter. 3.30=3.25	=?Utf-8?B?cGF0IGNhbm5pbmc=?=	Microsoft Excel Worksheet Functions	2	20th Feb 2006 05:49 PM