View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Darrell Dr. Darrell is offline
external usenet poster
 
Posts: 74
Default How can I Round up to the nearest .25

Thank you all. I have tried a few of these and they work. I will try more
later.

"Dr. Darrell" wrote:

How can I Round up to the nearest .25.

I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79.
I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00,
4.50, 5.00).

Is there a function for this?