I have a worksheet with 1000+ line and I need to write an if function to look
in one particular column to tell me if certain number are among the various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new column, I
want to write an IF function to say YES if the number is 1 of 3 numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano

Say your numbers are in column A. In another column enter:

=IF(OR(A1={200000,300000,400000}),"yes","no") and copy down

(based upon a suggestion from Harlan Grove)
--
Gary's Student


"Wannano" wrote:

I have a worksheet with 1000+ line and I need to write an if function to look
in one particular column to tell me if certain number are among the various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new column, I
want to write an IF function to say YES if the number is 1 of 3 numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano

=IF(OR(A1=200000,A1=300000,A1=400000),"YES","NO")
and copy down.
--
David Biddulph

"Wannano" wrote in message
...
I have a worksheet with 1000+ line and I need to write an if function to
look
in one particular column to tell me if certain number are among the
various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new column, I
want to write an IF function to say YES if the number is 1 of 3 numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano

Hi

Try
=IF(OR(A1=200000,A1=300000,A1=400000),"Yes","")
for the actual results of 200000,300000 and 400000

If, however, you wanted any numbers within the range of 200000 to 499999
then you would need
=IF(AND(A1=200000,A1<500000),"Yes","")

--
Regards

Roger Govier


"Wannano" wrote in message
...
I have a worksheet with 1000+ line and I need to write an if function
to look
in one particular column to tell me if certain number are among the
various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new
column, I
want to write an IF function to say YES if the number is 1 of 3
numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano

Thanks--it worked!!!!

Your're my HERO!
--
Texas Wannano


"Gary''s Student" wrote:

Say your numbers are in column A. In another column enter:

=IF(OR(A1={200000,300000,400000}),"yes","no") and copy down

(based upon a suggestion from Harlan Grove)
--
Gary's Student


"Wannano" wrote:

I have a worksheet with 1000+ line and I need to write an if function to look
in one particular column to tell me if certain number are among the various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new column, I
want to write an IF function to say YES if the number is 1 of 3 numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano

Assuming your account value is numerical and starts in cell A2:

=IF(OR(A2=200000,A2=300000,A2=400000),"yes","no")
--
T Tipsy


"Wannano" wrote:

I have a worksheet with 1000+ line and I need to write an if function to look
in one particular column to tell me if certain number are among the various
numbers listed in that column. Example:

Column contains account values from 100000 to 900000. In a new column, I
want to write an IF function to say YES if the number is 1 of 3 numbers
(200000, 300000 or 400000), otherwise NO.

I appreciate any assistance.

THANK YOU!

--
Texas Wannano