Round to Nearest 25 Percent?
 

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

Thanks,

Dave

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

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