Excel Formula Troubles

  • Thread starter Patrick.Killela
  • 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!!
 
G

Gord Dibben

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
 
Top