Rounding

B

Bill Ridgeway

Whets the formula for rounding to the nearest 10 please?

Thanks

Bill Ridgeway
 
N

Niek Otten

Hi Bill,

=ROUND(A1,-1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Whets the formula for rounding to the nearest 10 please?
|
| Thanks
|
| Bill Ridgeway
|
|
 
B

Bill Ridgeway

Thanks Niek,

I knew it was straight forward because I've done it before but just couldn't
recall how.

Regards.

Bill Ridgeway
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ROUNDING 9
ROUNDING NUMBERS 3
rounding to the nearest Dollar 2
rounding a number up to a certain ending digit 6
ROUNDING UP 2
in access, round up to nearest fraction(.5) 1
Notes in graphs 1
Divide a # into 3 #'s rounded to a whole # 9

Top