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