Microsoft Excel

[jellytot01]

When using Excel, is there anything you can do to round the figure to the nearest 10?

[rampart]

Have you tried the "round" function?

Example, you have the number 10,000.256 in cell D6.

In cell C6 type =round(D6,1)

That will round your number to 10,000.3

There is also the "left" and "right" feature.

If you type in cell F6   =LEFT(D6,3) you will get the number 100.

If you type in cell G6   =RIGHT(D6,2) you will get the number 56.

I hope some combination of this helps you.

[stevie21]

If your unrounded number is in cell A1 then put this in whichever column that you want to have the rounded number:
=ROUND(A1,-1)

[Ralph]

If you want to round down all the time, use the FLOOR function. If A1 has 56.28, =FLOOR(A1,x) will round down to whatever x is, x=10 the answer will be 50, x=5 the answer will be 55, x=1 the answer will be 56.

This might be one of the rare occasions where the online help may be of more assistance than a human!