ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 963
- Office Version
- 365
- 2010
- Platform
- Windows
Hi everyone,
My question is as follows:
I want to convert digits to a single value.
For example,
If a value in cell A1 equals:
digits 0 or 1 to value of 0
digits 2 or 3 to value of 1
digits 4 or 5 to value of 2
digits 5 or 7 to value of 3
digits 8 or 9 to value of 4
So if the value in cell A1 = 0 or 1 then the value = 0 in cell B1
if the value in cell A1 =8 or 9 then the value = 4 in cell B1
Thanks in advance!!
My question is as follows:
I want to convert digits to a single value.
For example,
If a value in cell A1 equals:
digits 0 or 1 to value of 0
digits 2 or 3 to value of 1
digits 4 or 5 to value of 2
digits 5 or 7 to value of 3
digits 8 or 9 to value of 4
So if the value in cell A1 = 0 or 1 then the value = 0 in cell B1
if the value in cell A1 =8 or 9 then the value = 4 in cell B1
Thanks in advance!!