Log in

View Full Version : How to roundup -1.2 to 0 in excel


mapech
Aug 29, 2012, 02:39 AM
If a number is less than 0 or negative then roundup to 0 and not to a negative interger

ebaines
Aug 29, 2012, 06:06 AM
I assume that if the number is positive you want to round up to the next largest integer, correct? If the number you want to round is in cell A1 this should work:

=if(A1>0,roundup(A1,0),0)

JBeaucaire
Aug 29, 2012, 09:37 PM
I would suggest:

=MAX(A1, 0)