#### joedavis123

##### New Member

- Joined
- Dec 27, 2005

- Messages
- 8

O = 4

C = 3

E = 2

N = 1

U = 0

I have two columns setup, the first one is where one of the above listed abbreviations is entered (O, C, E, N, U). The second column translates this into a score (4, 3, 2, 1, 0). I originally tried to have this value translated using a table, but had trouble getting this to translate every value (only O, E, and U would translate correctly). So I decided to use an IF statement instead on the second column:

=IF(A1="O","4","")&IF(A1="C","3","")&IF(A1="E","2","")&IF(A1="N","1","")&IF(A1="U","0","")

I know this might not be the proper way to do what I need, but it seems to translate properly. The problem I am encountering now is that SUM and AVERAGE statements at the bottom of the second column which calculates the numeric scores do not display anything other than a zero. If I enter the numeric values in manually into the second column, it works fine, so I think there is some problem with it reading the formula instead of the values it outputs. This might have to do with the way I am trying to implement the solution, so I am trying to find out if anyone can give me any pointers as to why this is happening, a way to fix it, or possibly a more efficient way to get these values to translate from letters to numbers.

Any help is greatly appreciated. Thanks