some numbers to be blank

[bill gras]

Hi
I have a column of 2000 rows with numbers in them (no formulas)
I need to select numbers between 40 and 60 and for every one of those
numbers I need a " yes " in the same row but a different column , and
all other numbers under 40 and over 60 left blank
eg: A B
1 999
2 135
3 44 YES
4 60 YES
5 13
6 196
7 999
8 56 YES
9 48 YES
10 128
11 14
and so on

Is there any one that can help me ?

thanks in advance

bill

 

[Mike H]

Hi,

Put this in B1 and fill down

=IF(AND(A1>=40,A1<=60),"Yes","")

Mike