Thread: How do I format cell to 0.25 resolution?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I format cell to 0.25 resolution?
Maybe

=ROUND(A1/0.25,0)*0.25

Mike

"Bugman" wrote:

I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50,
5.75, 6.00, ...).
Reply With QuoteReply With Quote