Rounding up numbers

  • Thread starter Michelle Nichols via OfficeKB.com
  • Start date
M

Michelle Nichols via OfficeKB.com

This may seem trivial as I am not to advanced in excel, but I need excel to
round up at .50 (as it stands right now if I have $3854.50 when I format
the cell to 0 decimals it rounds down to $3854) my company rounds up at
that number. Anybody know how to change that? Thanks!
 
J

JulieD

Hi Michelle

formatting a cell doesn't actually round numbers it just supresses the
display of the decimals (to test this, format your cell to show 3854.50 as
3854 and then in another cell multiply this formatted number by 100)

to round a number, use the round function
e.g.
=ROUND(A1,0)
to round to no decimal places
 
J

JE McGimpsey

By default, 3854.50 will round up to 3855. If your value is calculated,
try expanding the number of decimal places. I'll bet you'll see
something like 3854.499, which displays as 3854.50.

One possible solution:

=ROUND(A1+0.005,0)

You might want to take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html
 
Top