excelbetter
Board Regular
- Joined
- Oct 13, 2010
- Messages
- 190
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.
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.