| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round up to nearest 50p | Excel Discussion (Misc queries) | |||
| How to round up to the nearest five | Excel Discussion (Misc queries) | |||
| How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
| How do you round up to nearest 10??? | Excel Discussion (Misc queries) | |||
| How do I round to the nearest $250 | Excel Worksheet Functions | |||
Linear Mode
