Conditional rounding to the nearest .5

[Jack Schitt]

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

 

[DominicB]

Good afternoon Jack Schitt

Try this formula :

=CEILING(A1,0.5)

HTH

DominicB

 

[xapie128]

Note that negative numbers will result in an error.
If you anticipate having negative values, use:

=IF(A1>=0,CEILING(A1,0.5),CEILING(A1,-0.5))