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)

 

[Bob Phillips]

=ROUND(A1,-1)

--
HTH

Bob Phillips

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

 

[Pete_UK]

Try this:

=ROUND(A1,-1)

with your number in A1.

Hope this helps.

Pete

 

[Dave Peterson]

=ROUND(A1,-1)

is one way.

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

 

[Scott W]

Thanks to all

Try this:

=ROUND(A1,-1)

with your number in A1.

Hope this helps.

Pete