Thread: Rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Rounding
Hi Bill,

=ROUND(A1,-1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill Ridgeway" wrote in message ...
| Whets the formula for rounding to the nearest 10 please?
|
| Thanks
|
| Bill Ridgeway
|
|


Reply With QuoteReply With Quote