Rounding up to next quarter?

[JariV]

Hi,

Is there a simple way to round up numbers to next x,0, x,25, x,50 or x,75? For example, 16,58 would become 16,75.

Thanks in advance,

Jari V.

[comment]

Try;

Ceiling ( number / .25 ) * .25

[JariV]

Very elegant, thanks a lot.

Jari V.

[Peter (duksis3)]

Hi,

The first that comes in mind is:

N-number to be rounded UP

You can use Case or If.

In general formula is (Case):

Case [N-Int(N)>=0 and N-Int(N)<=0,25; Int(N)+0,25;

N-Int(N)>0,25 and N-Int(N)<=0,5; Int(N)+0,5;

N-Int(N)>0,5 and N-Int(N)<=0,75; Int(N)+0,75; Int(N)+1]