Excel Question...?

Question

I have a column of over 5000 cells. Each cell contains a number from 100 - 999. I want to set it up so that if Column "c" contains the number 101,104,105,276,632,635...etc then Column "H" will display the number 1.
Please help!

Answer 1

Use this in D1
=IF( OR( C1=101, C1=104, C1=105, C1=276, C1=632, C1=635), 1, "Empty")
This will check if C1 equals one of the values you entered here to show 1, and show "Empty" if it is not.
The C1=XXX section as you see is repeated inside the OR function.
You can put up to 30 conditions here, means OR accepts up to 30 times C1=XXX
If you have more than 30 conditions, or need more info, mail me here


Enjoy my profile, I am the VBAXLMan

Answer 2

Put this formula in column H:

=IF(LOOKUP(C1,I:I)=C1,1,"")

and in column I put your numbers, starting with 0:
0
101
104
105
276
...
etc.

The numbers in Column I need to be ascending. I'm not sure why. It also has to start with 0 or until the column gets its first match the result will be #N/A.

Answer 3

Hello
in Excle use IF

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
Use IF to conduct conditional tests on values and formulas.

Syntax
IF(logical_test,value_if_true,value_if_false)

Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.

You may use IF(Value, IF(Value,1,2), 2) nested if

Answer 4

I was going to tell you to use the IF factor, but Labib beet me to it!