?
Solved

How do I round  to nearest 0.5 in Excel?

Posted on 2003-03-26
4
Medium Priority
?
1,203 Views
Last Modified: 2012-08-13
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
Comment
Question by:egg_dan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
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

by:bruintje
ID: 8215586
along the same lines

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

Author Comment

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

Expert Comment

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question