round up/Ceiling

  • Thread starter Thread starter James P
  • Start date Start date
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.
 
Well,
It does not. It rounddowns all the figures below 30
however figures below 30 appear the same. I need some
more help.
 
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
 
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
 
Back
Top