ExcelBanter - some numbers to be blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - some numbers to be blank (https://www.excelbanter.com/excel-worksheet-functions/246808-some-numbers-blank.html)

some numbers to be blank

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

--
bill gras

some numbers to be blank

Hi,

Put this in B1 and fill down

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

Mike

"bill gras" wrote:

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

--
bill gras