# Conditional rounding to the nearest .5

#### Jack Schitt

##### New Member
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

### Excel Facts

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
Good afternoon Jack Schitt

Try this formula :

=CEILING(A1,0.5)

HTH

DominicB

#### xapie128

##### Board Regular
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))``

Replies
3
Views
58
Replies
3
Views
32
Replies
6
Views
132
Replies
1
Views
125
Replies
3
Views
389