Using OR and If function
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
|