Rounding

[Scott W]

How can I format the result of a simple formula to give the result rounded
to the nearest 10? Example, 1178 displayed as 1180 (no decimals)

[oldchippy]

How can I format the result of a simple formula to give the result rounded
to the nearest 10? Example, 1178 displayed as 1180 (no decimals)

Hi Scott,

you didn't say whether it was rounding up or down, try these

=ROUNDUP(A1,-1)

=ROUND(A1,-1)

=ROUNDDOWN(A1,-1)

oldchippy

[Bob Phillips]

=ROUND(A1,-1)

--
HTH

Bob Phillips

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

"Scott W" <[email protected]> wrote in message
news:[email protected]...
> How can I format the result of a simple formula to give the result rounded
> to the nearest 10? Example, 1178 displayed as 1180 (no decimals)
>
>

[Pete_UK]

Try this:

=ROUND(A1,-1)

with your number in A1.

Hope this helps.

Pete

Scott W wrote:
> How can I format the result of a simple formula to give the result rounded
> to the nearest 10? Example, 1178 displayed as 1180 (no decimals)

[Dave Peterson]

=ROUND(A1,-1)

is one way.

Scott W wrote:
>
> How can I format the result of a simple formula to give the result rounded
> to the nearest 10? Example, 1178 displayed as 1180 (no decimals)

--

Dave Peterson

[Scott W]

Thanks to all

"Pete_UK" <[email protected]> wrote in message
news:[email protected]...
> Try this:
>
> =ROUND(A1,-1)
>
> with your number in A1.
>
> Hope this helps.
>
> Pete
>
> Scott W wrote:
> > How can I format the result of a simple formula to give the result
rounded
> > to the nearest 10? Example, 1178 displayed as 1180 (no decimals)
>