Excel Formula Troubles

  • Thread starter Thread starter Patrick.Killela
  • Start date Start date
P

Patrick.Killela

I'm having trouble with excel formulas.......

If i have a large table with numerical data and i am interested in
writing a formula that will take all cells with #'s greater then 2 and
replacing that # with the word "Up".

Is this possible?

Any Feedback is appreciated

Thanks!!
 
Formulas cannot replace values in another cell.

They can only return results into the cell in which they are written.

You would need a macro to replace.

Sub change_to_Up()
Dim rr As Range
For Each rr In Selection
If rr.Value > 2 Then
rr.Value = "Up"
End If
Next rr
End Sub


Gord Dibben MS Excel MVP
 
Back
Top