Character as a Number

[Jani]

Is the way to do this with If statements or does someone have a better idea
(I sure hope so!)?
A character in column A = 0; char in col B=2; char in col C=4; char in col
D=6 and so on. In a row, only one character can be put in a row in one of the
four columns, and the same character must always be used consistently. The
row is then summed and a percentage taken from another cell. For example, in
Row 2, there's an 'x' in col C - the sum of the row would be 4. Clear? (as
mud); in Row 3, there's an 'x' in Col D so the sum of the row would be 6.
Thanks!!! Jani

 

[Gary''s Student]

=(MATCH("*",A1:E1,0)-1)*2
for the first four cells in row 1

No IFs were needed

 

[Jani]

I don't understand the formula and would appreciate it if you would tell me
how this works. It is so close. What I'm finding, however, is that when an *
is put in a cell in a row the formula works fine but it allows another * to
be added to the same row and that can't be allowed. How would this formula be
changed to accomodate that? Would it be to count the *'s and if more than one
have a statement displayed. Appreciate your help very much!!! Jani

 

[Jani]

I got it figured out! Thanks!

 

[Gary''s Student]

Preventing more than one cell from being filled can be done with Data
Validation