Thread: Rounding decimals up or down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Rounding decimals up or down
Try

=ROUND(A1/0.25,0)*0.25

Mike

"Friedbrain" wrote:

I've read loads of previous posts but can't find exactly what I'm after.

I need to be able round a decimal number up OR down to the nearest 0.25, eg

1.05 needs to be 1.0
1.12 needs to be 1.0
1.19 neeeds to be 1.25
1.39 needs to be 1.5 etc.....

Many Thanks
Reply With QuoteReply With Quote