R
Robert
How can I apply the ROUNDUP formula to several cells with different munbers
at the same time without having an error.
at the same time without having an error.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
bar, then hit Ctrl-Enter..
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
G
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
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
R
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.
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.