Rounding up numbers

[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!

[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
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Michelle Nichols via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
message news:1e7413c501884273917b1e4ff2df9d8d@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!

[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


In article <1e7413c501884273917b1e4ff2df9d8d@OfficeKB.com>,
"Michelle Nichols via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote:

> 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!