formulas

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

How can I apply the ROUNDUP formula to several cells with different munbers
at the same time without having an error.
 
Select all the cell, enter the formula for the first cell in the formula
bar, then hit Ctrl-Enter..

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If formulas already exist without the ROUNDUP function, you could add the
function using a macro.

Sub RoundUp_Add()
Dim myStr As String
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = True Then
If Not cel.Formula Like "=ROUNDUP(*" Then
myStr = Right(cel.Formula, Len(cel.Formula) - 1)
cel.Value = "=ROUNDUP(" & myStr & ",3)" 'adjust the 3 to suit
End If
End If
Next
End Sub


Gord Dibben MS Excel MVP
 
Bob,

When I do that every cell from the multiple choice turns into the same
value, eventhough I got different values. Do you have anything else on mind.
 
Back
Top