ROUNDDOWN & ROUNDUP in same formula?

**Grasshopper Green** · 04-05-2013, 05:54 PM

Here is my situation. I track product for shipping and convert pieces into shippable cases. If I don't have enough product to fill a case, I have my excel sheet round down so I know how many full cases I have. If my product is in the negative (for estimations), I'd like it to round up so I can see how many full cases I am potentially in the hole. Right now I have the column I track this with set to rounddown only, so it doesn't work for the negative numbers. Can I get both round up and round down in one formula?

Thanks!

**dilipandey** · 04-06-2013, 03:54 AM

HI Grasshoper,

Can you share a sample excel workbook along with expected results. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**JBeaucaire** · 04-06-2013, 04:03 AM

You will have to create two formulas, one to roundup, one to rounddown. Then use a IF/THEN/ELSE test to decide which formula to use.

=IF(A1<0, ROUNDUP(formula), ROUNDDOWN(formula))

**Grasshopper Green** · 04-06-2013, 08:32 AM

Originally Posted by JBeaucaire

You will have to create two formulas, one to roundup, one to rounddown. Then use a IF/THEN/ELSE test to decide which formula to use.

=IF(A1<0, ROUNDUP(formula), ROUNDDOWN(formula))

I will try this at work on Monday. Thank you.

DILIPandey, I have tried uploading sheets before without success, I'm not sure what I end up doing wrong. Thank you for your offer, though.