Search code examples
excelexcel-formularoundingworksheet-function

Round up decimals to fractional multiple

I am trying to round up decimals to specific values in the following way:

1. 12.12 ---> 12.25
2. 12.5  ---> 12.5
3. 12.59 ---> 12.75
4. 12.75 ---> 12.75
5. 12.77 ---> 13

So they should be rounded up to the decimals .25, .5 and .75 or integer.
Is there an Excel function which can do this?

Solution

  • Please try: 

    =ROUNDUP(4*A1,0)/4