Conditional rounding to the nearest .5

Jack Schitt

New Member
Joined
Jan 24, 2006
Messages
2
Ok, let's see if I can state the problem correctly. I'm trying to find a good way to round a decimal number UP to the neaest .5 increment. Here's some examples of the data and what I want to return within the cell equation:

DATA............RETURN (what I'm try to do)
3.4298..........3.5
4.1678..........4.5
2.7345..........3.0
4.0012..........4.5

the data shown above is part of a calculated equation as follows (example): =(C546+H546)/24/2. How can I round up to the nearest .5 increment???

Thanks for any help!

Jack
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon Jack Schitt

Try this formula :

=CEILING(A1,0.5)

HTH

DominicB
 

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
Note that negative numbers will result in an error.
If you anticipate having negative values, use:
Code:
=IF(A1>=0,CEILING(A1,0.5),CEILING(A1,-0.5))
 

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,363
Members
410,911
Latest member
AniEx
Top