Use a macro

This routine, for example, will roundup user selected cells to the next
higher integer value:

Sub roundupp()
Dim r As Range
For Each r In Selection
With r
v = Int(.Value) + 1
.Value = v
End With
Next
End Sub


--
Gary''s Student - gsnu200834


"Mike B" wrote:

How do I get a number in a cell rounded up without having to perform the
ROUNDUP function in another cell.

Mike