[ARCHIVED THREAD] - Excel gurus:

Posted: 9/5/2011 11:57:55 AM EDT

What do I add to my formula to make it round up or down? Example, the par on an item is 2 and the on hand is .9. I want to order 1, not 1.1. My original formula is SUM=(A1-B1), very simplistic. So I want the "order" column to reflect a rounded order, with .5 as the round up mark. Thanks!

Posted: 9/5/2011 12:02:25 PM EDT

[#1]

If I remember right, use FIX(<number>,<digits>).

Posted: 9/5/2011 2:19:38 PM EDT

[#2]

Or you can just highlight the affected cells, right click, choose Format As <NUMBER> from the menu, then select the appropriate number of places to round to in the box provided. Easy.

Posted: 9/5/2011 2:22:19 PM EDT

[#3]

=ROUND(A1-B1,0)

Posted: 9/5/2011 3:55:02 PM EDT

[#4]

There is also ROUNDUP(cell, # digits) and ROUNDDOWN(cell, #digits)

Posted: 9/5/2011 4:00:19 PM EDT

[#5]

round(input , num_digits) rounds off. I think that you want this.
ceiling(input , num_digits) rounds up
floor(input , num_digits) rounds down

Posted: 9/5/2011 8:46:21 PM EDT

[#6]

Thanks folks, got it programmed!

[ARCHIVED THREAD] - Excel gurus:

Warning

Confirm Action

[ARCHIVED THREAD] - Excel gurus:

[ARCHIVED THREAD] - Excel gurus: