Formula Help

[ststern45]

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!!

 

[Scott T]

Try this. assuming there are no negative values as this will return 0
=IF(A1<=1,0,IF(A1<=3,1,IF(A1<=5,2,IF(A1<=7,3,IF(A1<=9,4)))))

 

[ststern45]

Thanks that worked.
I also found this formula INT(A1*.5)
Thnaks for all your help!!