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

On Tue, 8 Jul 2008 10:08:54 -0700 (PDT), (E-Mail Removed) wrote:

>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!!