Thread: Round number to whole No 25
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Round number to whole No 25
My personal preference as it does not require the Analysis Toolpack is this...

=round(A1/25, 0) * 25

Where the number to be rounded is in A1
--
HTH...

Jim Thomlinson


"lahaina" wrote:

How do you round a number to the nearest $25?
Reply With QuoteReply With Quote