Multi IF statament
 

I am trying to build an IF statement that would apply and I could copy
accross as a formula. I want to include in the cell C3 an IF query that would
populate the cell based on the value in Column B3, B4, B5 etc.

If the cell in Column B is "c" then I need to return a value 3, if it is "d"
then return a value 4, if it is "e" then return a value 5. There could be
multiple iterations in the same column, multiple a/b/c/d etc. Then in the
next cell (column) have the same function? Hope this makes sense
ROW c d e f g h
COLUMN
3 c 3 3 3 3 3 3
4 d
5 e
6 f
7 g
8 h
9 c 9 9 9 9 9 9
10 d
11 e
12 f
13 g

Multi IF statament
 

Hazarding some thoughts ..

Presuming the single lower case alphas: a,b,c,d,... z
are running in B3 down

Put in C3: =IF(B3="","",CODE(B3)-96)
Copy C3 down to return the required numeric values in the column
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AMM19" wrote:
I am trying to build an IF statement that would apply and I could copy
accross as a formula. I want to include in the cell C3 an IF query that would
populate the cell based on the value in Column B3, B4, B5 etc.

If the cell in Column B is "c" then I need to return a value 3, if it is "d"
then return a value 4, if it is "e" then return a value 5. There could be
multiple iterations in the same column, multiple a/b/c/d etc. Then in the
next cell (column) have the same function? Hope this makes sense
ROW c d e f g h
COLUMN
3 c 3 3 3 3 3 3
4 d
5 e
6 f
7 g
8 h
9 c 9 9 9 9 9 9
10 d
11 e
12 f
13 g

Multi IF statament
 

The earlier suggestion presumes
you want the numbers for: a,b,c,d,... z (in col B)
returned as: 1,2,3,4,...26 (in col C)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---