PC Review


Reply
Thread Tools Rate Thread

How can I round in quarter points?

 
 
=?Utf-8?B?ZnJ1bWlvdXM=?=
Guest
Posts: n/a
 
      10th Jul 2006
I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00 for
example
 
Reply With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      10th Jul 2006
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



 
Reply With Quote
 
macropod
Guest
Posts: n/a
 
      10th Jul 2006
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

>
>



 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      10th Jul 2006
"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


 
Reply With Quote
 
bplumhoff@gmail.com
Guest
Posts: n/a
 
      10th Jul 2006
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:00 AM.