round up/Ceiling

J

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.
 
J

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.
 
H

Harald Staff

James P said:
Well,
It does not. It rounddowns all the figures below 30
however figures below 30 appear the same. I need some
more help.
Click to expand...

Nonsense. Both solutions do exactly what you described.

Best wishes Harald
 
S

Sandy Mann

James P said:
Well,
It does not.
Click to expand...

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
 
Top