Excel Rounding to 0.25 from Mr Excel
 Search   Memberlist   Usergroups   Favorites   Statistics   Register

 Rounding to 0.25

Mel C Roberts
Board Regular

Joined: 27 Feb 2002
Posts: 34
Location: England

Status: Offline

Rounding to 0.25

I need to round information in a spreadsheet to the nearest 0.25
So data either reads, for example, 1.25, 1.50, 1.75 or 2.00 and nothing in between i.e. if the value is 1.3 it would round down to 1.25 and if it was 1.4 it would round up to 1.5

I am sure this is not too tricky but is driving me crazy!!

Tue Mar 30, 2004 9:56 am

rafaaj2000
Board Master

Joined: 06 Dec 2002
Posts: 1002
Location: Larache--Morocco
Flag:

Status: Offline

Re: Rounding to 0.25

Hi,

Use the Ceiling and Floor functions as :

=CEILING(A1,0.25)
=Floor(A1,0.25)

Regards.
_________________
Jaafar. .

Excel2002 Under Windows XP.

Tue Mar 30, 2004 10:03 am

Richie(UK)
MrExcel MVP

Joined: 18 May 2002
Posts: 2497
Location: UK
Flag:

Status: Offline

Re: Rounding to 0.25

Hi Mel,

How about MRound from the Analysis toolpack?

 Microsoft Excel - Book1 ___Running: xl97 : OS = Windows ME
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B1B2B3B4B5B6B7 =

A
B
C
D
1
0.650.75
2
0.800.75
3
1.301.25
4
1.401.50
5
1.511.50
6
1.651.75
7
1.731.75
 Sheet1

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

HTH
_________________
««« ¤ Richie ¤ »»»

Tue Mar 30, 2004 10:04 am
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

Forum Jump:
 Jump to: Select a forum MrExcel Forums----------------Excel QuestionsInternational forumMicrosoft AccessTechnical issues and Future development Holy Macro! Books----------------Holy Macro! Products The Lounge----------------Max Cells Lounge Announcements----------------About This BoardHall of Fame WinnersTest Here

Page 1 of 1

Forum Rules:
 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum