Rounding in Excel

[Genny Santos]

One cell in an Excell spreadsheet contains a mathematical formula and the
answer is always a decimal out to at least 6 places. I need to program that
cell so that it will round as follows: If the 6th decimal place number is 5
or less, round down to 5 decimal places. If the 6th place number is 6 or
more, round up to 5 decimal places. Here's an example. Let's say the
formual results in .005395833. I need it to round to .00539. However, if
the formula results in .00626639, I need it to round to .00627

[Bob Phillips]

=ROUND(A21-0.000001,5)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Genny Santos" <Genny Santos@discussions.microsoft.com> wrote in message
news:4C0DB00C-E1DC-4C31-80A4-5A98FDEC6142@microsoft.com...
> One cell in an Excell spreadsheet contains a mathematical formula and the
> answer is always a decimal out to at least 6 places. I need to program
that
> cell so that it will round as follows: If the 6th decimal place number is
5
> or less, round down to 5 decimal places. If the 6th place number is 6 or
> more, round up to 5 decimal places. Here's an example. Let's say the
> formual results in .005395833. I need it to round to .00539. However, if
> the formula results in .00626639, I need it to round to .00627

[Genny Santos]

Thanks, Bob. That's exactly what I needed. I think you just became my new
best friednd!!!!

"Genny Santos" wrote:

> One cell in an Excell spreadsheet contains a mathematical formula and the
> answer is always a decimal out to at least 6 places. I need to program that
> cell so that it will round as follows: If the 6th decimal place number is 5
> or less, round down to 5 decimal places. If the 6th place number is 6 or
> more, round up to 5 decimal places. Here's an example. Let's say the
> formual results in .005395833. I need it to round to .00539. However, if
> the formula results in .00626639, I need it to round to .00627