Excel 200 Roundup feature

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you
 
You can roundup a cell value in another cell, but you cannot format the cell
to roundup.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Semantics Bob.<bg>

True, you cannot *format* a cell to roundup, but you can *formulate* the
cell to roundup, *without* needing an additional cell.

Need some specific examples in order to offer any suggestions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

You can roundup a cell value in another cell, but you cannot format the cell
to roundup.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You can't format a cell to round up, but you can use an event macro:

Put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim rTargets As Range
Dim rCell As Range
Set rTargets = Intersect(Target, Range("A1:A10,B2,J10"))
If Not rTargets Is Nothing Then
For Each rCell In rTargets
With rCell
If IsNumeric(.Value) Then
Application.EnableEvents = False
.Value = Application.RoundUp(.Value, 0)
Application.EnableEvents = True
End If
End With
Next rCell
End If
End Sub


Change the Range("A1,B2,J10") to suit.
 
Do you literally mean round 'UP' (9.2 > 10), or just round to the nearest
decimal place (9.2 > 9, 9.6 > 10)
 
If I may jump in here if it isn't to late and this thread isn't looked
at any more.

I too need to round up a cell formula.

In a cell I have =D5/100. I need the result to always round up,
example 9.2 would be 10.

Thanks

Jess
 
Back
Top