Code?
iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
For i = 1 to iLastRow
If Cells(i,"A").Value =7 Then
Cells(i,"A").Value = "YES"
Else
Cells(i,"A").Value = "NO"
End If
Next i
--
HTH
RP
(remove nothere from the email address if mailing direct)
"thanks" wrote in message
...
I need to change all the column at the same time, not cell by cell.
Thank you!
"Bob Phillips" wrote:
=IF(A1=7,"YES","NO")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"thanks" wrote in message
...
Hello,
If a have a colum with numbers and want to convert the numbers =7 to
"YES"
and the numbers <7 to "NO", what formula should I use?
Example
A
9
10
2
With the formula I must see:
A
YES
YES
NO
Thank you!
|