Excel : Rounding Off To Nearest 50 Cents

Are you trying to round-off your Excel spreadsheet numbers to the nearest .50? Here's how.

Let's assume you have the unrounded figure in cell A1.

Here's the formula to round-off that figure to the nearest .50

=FLOOR(A1+0.25,0.5)

Hence, if cell A1 contains 1.6, it will be rounded off to 1.5
while if it contains 1.75 it will be rounded off to 2.

If you wish to round off to the nearest 25 cents:

=FLOOR(A1+0.125,0.25)

Or, to make it more generic:
=FLOOR(A3+ half of the nearest figure, round off to the nearest figure)

If you want the rounded figure in multiples of 50:
=FLOOR(A3+25,50)

I hope you find this Excel formula tip useful.
[ First posted on 09/13/2005 by Manuel Viloria ]



Do you LIKE this page? Please let us know, and we will publish more of the content that YOU want. Salamat po!


"Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!"

To Grab This Offer, Click Option Below:

Truly Rich Club Philippine Residents Click Here

Truly Rich Club International Residents Click Here



Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka

Get In Touch With Manuel Today
Manuel@Viloria.net



  Previous Entry
  Next Entry




Secondthoughts @ Viloria.com
"Invest in yourself, before
others will invest in you."
-- Manuel Viloria


Viloria.com
About Manuel Viloria
Secondthoughts
Archives
Angelhouser
Contact Us
Privacy Statement
RSS Feed


Google Reader


Copyright © 1996 - 2015 by Viloria.com All Rights Reserved.