Thread: Need help in rounding answers to nearest multiple
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Need help in rounding answers to nearest multiple
=ROUND(A1,-1) rounds A1 to the nearest multiple of 10.
Regards,
Stefi



€˛Wasatch€¯ ezt Ć*rta:

Is there a formula or method of calculation that can be used when working
with Excel worksheets that can round the answer to the nearest multiple of
the answer, such as rounding for multiples of 10?

I am using Excel Office 2000
Reply With QuoteReply With Quote