formulas

[Robert]

How can I apply the ROUNDUP formula to several cells with different munbers
at the same time without having an error.

 

[Bob Phillips]

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)

 

[Gord Dibben]

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

 

[Robert]

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.