Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# How do I round  to nearest 0.5 in Excel?

Posted on 2003-03-26
Medium Priority
1,229 Views
Hi,

I need to round some certain values in a spreadsheet to the nearest 0.5. Is this possible? I seem only to be able to find the ROUND() and ROUNDUP() functions.

Would greatly appreciate any help,

thanks
0
Question by:egg_dan
• 2

LVL 9

Accepted Solution

pauloaguia earned 200 total points
ID: 8214308
you mean

4.4 -> 4.5
4.2 -> 4.0
4.6 -> 4.5
4.8 -> 5.0

?

Then I think this will work:

=ROUND(A6 * 2;0)/2

Hope this helps

Paulo
0

LVL 44

Expert Comment

ID: 8215586
along the same lines

=ROUND(A1/.5,0)*.5
0

Author Comment

ID: 8216922
thanks for the quick responses - can't believe I didn't think of that!
0

LVL 9

Expert Comment

ID: 8219940
thank you for the points and grade and welcome to EE :)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
###### Suggested Courses
Course of the Month12 days, 8 hours left to enroll