Thread: How do I round a number to the nearest 600 in Excel?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
  
Posts: 740
Default How do I round a number to the nearest 600 in Excel?
disregard the previous
i am confused
maybe with this another overkill
=IF(ABS(A1)<600,SIGN(A1)*600,ROUND(A1/600,0)*600)
--
*****
birds of the same feather flock together..



"driller" wrote:

just literally maybe
=MAX((A1<600)*600,ROUND(A1/600,0)*600)
for +/- numbers only
--
*****
birds of the same feather flock together..



"Barcelona" wrote:

I need to round numbers to the nearest multiple of 600. For example if the
number is 15,443, I am looking for a formula that would round the number to
15,600. Is there one?

Judy Sanchez

Reply With QuoteReply With Quote