I need help rounding

Copper Contributor

I need a value in a cell to round towards 0 if it is negative, but if it is positive, I need the value to round away from zero. Does anyone know how to do this?

3 Replies
how about INT(number)+1
Excel has a round down and up function, would this work?
=+IF(A1>0,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

@Alayiak 

=CEILING(A1,1)

or like