Steve Eckerman
asked on
Excel Rounding Numbers
Hello experts,
In column K, I need a formula that will round the numbers in Column H (# of skids) up to the nearest whole number. Even if the number is 1.001 it should be rounded up, not down, and appear as "2".
Thanks
Drew
weights-ex.xls
In column K, I need a formula that will round the numbers in Column H (# of skids) up to the nearest whole number. Even if the number is 1.001 it should be rounded up, not down, and appear as "2".
Thanks
Drew
weights-ex.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=CEILING(K1,1)