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)