View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Rounding number to 0.25 ?

Hi Construk

Try function mround(<number,0.25) which rounds <number to the nearest
multiple of 0.25.

Scott


"Construk" wrote:

Hi,

How can I round numbers with cell formating to show numbers round to 0.25
0.50 0.75 or 0.00 ?

Thanks