Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to roundup -1.2 to 0 in excel (https://www.askmehelpdesk.com/showthread.php?t=697839)

  • Aug 29, 2012, 02:39 AM
    mapech
    How to roundup -1.2 to 0 in excel
    If a number is less than 0 or negative then roundup to 0 and not to a negative interger
  • Aug 29, 2012, 06:06 AM
    ebaines
    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)
  • Aug 29, 2012, 09:37 PM
    JBeaucaire
    I would suggest:

    =MAX(A1, 0)

  • All times are GMT -7. The time now is 07:00 PM.