For <7 and 7 use a helper column and this formula copied down that column.
=IF(A17,"YES","NO")
What do you want to do with numbers that are exactly 7?
=IF(A17,"YES",IF(A1<7,"NO",7)) will return 7 if 7, otherwise YES or NO.
Gord Dibben Excel MVP
On Mon, 18 Apr 2005 15:47:02 -0700, thanks
wrote:
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!
|