I need help rounding

Occasional Visitor

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?



or like