How to round to nearest half dollar?

T

tcullen

Board Regular
Joined
Jun 15, 2005
Messages
79
I am trying to figure ou how to round my numbers to the nearest half dollar? The ROUND function doesnt seem to work for me, it only does nearest dollars..
ex)
56,498.56 I want it to say 56,499.00

And if it’s 48,567.37 I want it to round up to 48,567.50
Thanks
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
I am trying to figure ou how to round my numbers to the nearest half dollar? The ROUND function doesnt seem to work for me, it only does nearest dollars..
ex)
56,498.56 I want it to say 56,499.00

And if it’s 48,567.37 I want it to round up to 48,567.50
Thanks
Click to expand...

If you have the ATP (or if you have Excel 2007) just use mround(a1,.5)
otherwise try round(a1/5,1)*5
 
Upvote 0
Try this presuming the original value is in cell A2 :

Code: 
=IF(ROUND(A2,0)<A2,ROUND(A2,0)+0.5,ROUND(A2,0))

Erik
 
Upvote 0
Thanks.. the second suggestion works, however..if the number is say 48,657.20 (or anything lower than .25), how woudl I get it to return 48657.00?
 
Upvote 0
I am trying to figure ou how to round my numbers to the nearest half dollar? The ROUND function doesnt seem to work for me, it only does nearest dollars..
ex)
56,498.56 I want it to say 56,499.00

And if it’s 48,567.37 I want it to round up to 48,567.50
Thanks
Click to expand...

Hi tcullen:

From the data and expected result you have posted one way would be to use the ROUNDUP function ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
ABC
1
256498.5656499.00
348567.3748567.50
4
Sheet1


</body></html>

I hope this helps.
 
Upvote 0
=ROUND(A1*2,0)/2

This works by manipulating excel into using normal rounding rules, This way if you have, e.g. 5.20 it will first multiply but 2, to 10.4, which is then rounded to 10. This is then divided by 2 making 5 which is what you wanted.
 
Upvote 0
I am reading your original post again and I am now confused. Do you want it to round to the NEAREST HALF DOLLAR, or ROUND UP to the HALF DOLLAR? These are two different things.
 
Upvote 0
Or you could use mround(a1,.5) which will round up to the nearest multiple of .5
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Rounding Negative time to the nearest minute in Excel
Replies
4
Views
541
Scott Huish
Scott Huish
M
  • Solved
Rounding to the nearest 0.25?
Replies
6
Views
863
Fluff
Fluff
B
  • Solved
Need to add two sets of minutes with custom formatting and round
Replies
1
Views
415
bh24524
B
C
  • Question
Conditional formatting using formula to always round up a number
Replies
1
Views
190
arthurbr
arthurbr
N
  • Solved
Vstack, Chooserows & Dollar
2
Replies
18
Views
1K
Nathan Asius
N

Forum statistics

Threads
1,220,941
Messages
6,156,980
Members
451,388
Latest member
fitzmorrispr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top