IF Statement, convert...

[excelbetter]

If I have a bunch of numbers in Column A, all between the value of 1 - 10, how can I in Column B covert the # in Column A if the number is a specific number?

For example:

- If the number in column A is a 9 or 10, I want the number in column B to be a 10;

- If the number in column A is a 7 or 8, I want the number in column B to be a 1;

- If the number in column A is 1 through 6, I want the number in column B to be a 0;

Thanks.

 

[AhoyNC]

Try:

[TABLE="width: 176"]
<colgroup><col width="176"></colgroup><tbody>[TR]
   [TD="width: 176"]=IF(A1<7,0,IF(A1<9,1,10))[/TD]
 [/TR]
</tbody>[/TABLE]

 

[excelbetter]

That does not work. Not getting the right results.

 

[vlady]

base on your condition above the if statement should work. post2
another approach is =LOOKUP(A1,{0,7,9},{0,1,10}) ->change the numbers inside the braces to suit.

 

[excelbetter]

This is perfect. Thanks for the help!!

 

[vlady]

Glad to help.
Regards,
Vladimir

 

[AhoyNC]

I would stick with vlady formula, but IF works when I try it.

Excel Workbook
	A	B	C
1	1	0
2	2	0
3	3	0
4	4	0
5	5	0
6	6	0
7	7	1
8	8	1
9	9	10
10	10	10
11
Sheet1