If a number is less than 0 or negative then roundup to 0 and not to a negative interger
![]() |
If a number is less than 0 or negative then roundup to 0 and not to a negative interger
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)
I would suggest:
=MAX(A1, 0)
All times are GMT -7. The time now is 07:00 PM. |