Thread: How do I round to the nearest 25 cents in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Kuunders Bill Kuunders is offline
external usenet poster
  
Posts: 303
Default How do I round to the nearest 25 cents in Excel?
one way

number is in A1
=ROUND(A1/25,2)*25
formatted to two fixed decimals


--
Greetings from New Zealand

" wrote
in message ...
How do I round to the nearest 25 cents in Excel?


Reply With QuoteReply With Quote