round up/Ceiling

[James P]

I would like to use 30 for decimal rather than 50.
Basically I have a few coloums and I want the figures to
accept 30 as a ceiling. 12.29 will be rounded down to 12
however 12.30 and above will be rounded up to 13. If this
is possible please help me.

 

[Harald Staff]

=ROUND(A1+0.2,0)

HTH. Best wishes Harald

 

[duane]

this should work


=ROUNDDOWN(value,0)+IF(value-INT(value)>=0.3,1,0

 

[James P]

Well,
It does not. It rounddowns all the figures below 30
however figures below 30 appear the same. I need some
more help.

 

[Harald Staff]

Well,
It does not. It rounddowns all the figures below 30
however figures below 30 appear the same. I need some
more help.

Nonsense. Both solutions do exactly what you described.

Best wishes Harald

 

[Sandy Mann]

Well,
It does not.

Well,
It does for me, although I would have written it as:

=ROUNDDOWN(A1,0)+(A1-INT(A1)>=0.3)
or
=ROUNDDOWN(A1,0)+(MOD(A1,1)>=0.3)

But Harald's formula is the way to go thought

Regards

Sandy