Posted to microsoft.public.excel.programming
|
|
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
|