View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Godinger David Godinger is offline
external usenet poster
 
Posts: 22
Default Round to Nearest 25 Percent?

Hi, Tom,

Thanks, as always!

This formula does the job for me.

Dave



Tom Ogilvy wrote:

=ROUND(D4/0.25,0)*0.25

--
Regards,
Tom Ogilvy

"David Godinger" wrote:

Is there a way to round a number to the nearest 25 percent, such as 2.25 or
2.75?


--
Please delete "ANTI-SPAM" from email address
David Godinger: Go player, student of Mahatma Gandhi, the Buddha, and Dr. Martin King