Ask Experts Questions for FREE Help !
Ask
    mapech's Avatar
    mapech Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 29, 2012, 02:39 AM
    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
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

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

    =MAX(A1, 0)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Excel 'roundup' How do I? [ 1 Answers ]

I have a list of figures.. they a various and I need to calculate 50% in a separate column which I have done. I now need to feed the resulting list into a rather antiquated system in order to process the service I am providing. The problem is this (my) system will not accept a number that...

IF with ROUNDUP help please? [ 6 Answers ]

I am struggling to make this formula work. It seems to round up to 1 or 0, but not to 2 or 3. I would really appreciate any advice. =IF(B29<1,0,ROUNDUP(((B29/Input!$C$3/Input!$C$19/Schedule!B30)-B35)>0,0))

Does Roundup really kill crabgrass? [ 2 Answers ]

I have an area about 20 feet by 30 feet that is infested with crabgrass. It's about 99 percent crabgrass and 1 percent centipede grass. I was told that Roundup would kill the crabgrass. What I wanted to do is completely kill everything in this area and just resod it, hoping that new sod...

Puppy got into Roundup. [ 5 Answers ]

Hi, the family puppy which is a Golden Retriever/Lab/Shepard X found an empty container of roundup out on my parents farm. My dad does not know where she found it, but he caught her chewing on it, and yelled at her. She's 10 months old now, and he said that she was throwing up and wouldn't eat...

View more questions Search