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)

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

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.

"Bob Phillips" wrote:

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)

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

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

On Fri, 2 May 2008 09:16:00 -0700, Robert
wrote:

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