Rounding to nearest 0.25

[Guloluseus]

I have a table of task durations which have been calculated from actual dimensions (length, area etc) which are then divided by the expected outputs to get a total duration.

This gives me a column of numbers representing task durations in days. To use this, I need to round up each duration to the nearest quarter day to avoid problems.

In this case if I had 2.1, 2.224, 2.06, all would need to be rounded to 2.25, and 2.55, 2.7, 2.6 would need to be rounded up to 2.75. Tasks are all below 20 days, so range is 0-20.



Thanks in advance

[Guloluseus]

I just solved this- suffered from a case of number blindness at the last hurdle I was trying to use mround but it rounded to the nearest 0.25- I used an IF statement so that if the new value was less than the original it moved it up a band.

Yay!

[Pecoflyer]

You also have the CEILING function

=CEILING(B22,0.25)

[Guloluseus]

Thanks- much easier than my solution!

The biggest problem I have with Excel is not knowing the functions. While it often has an easy way out, if you don't know about it, you are unlikely to find it. Google gave me mround and I figured out the IF statement, but didn't throw up ceiling as an alternative.

[Pecoflyer]

That's understandable. There are lots of functions, and each versions has it's new ones.

And I supposed you guessed that if there is a CEILING function, there also is a FLOOR function :-)

[macropod]

More easily understood for most people:
=ROUND(A1*4,0)/4
Works with ROUNDUP & ROUNDDOWN, too.