Problems with IF formula with 4 IFs

[sveinhelge.urdal]

I have a column A with four different status descriptions. I want to convert this in to a number for each code.

Accepted = 1
Accepted with comments = 2
Not accepted, revise and resubmit = 3
For information only =4


I have tried this formula: '=IF(A2="Accepted";"1";IF(A2="Accepted with comments";"2";IFA2="Not accepted, revise and resubmit";"3";IF(A2="For information only";"4”))))

Can anyone hlp me solve this?

 

[vletm]

sveinhelge.urdal
=IF(A2="Accepted";1;IF(A2="Accepted with comments";2;IF(A2="Not accepted, revise and resubmit";3;IF(A2="For information only";4;"-"))))

 

[sveinhelge.urdal]

Thanks for the quick help. It works perfect.

 

[bosco_yip]

Or you could use Match function instead of 4 If function, as in:

=IFERROR(MATCH(A2;{"Accepted";"Accepted with comments";"Not accepted, revise and resubmit";"For information only"};0);"-")

Regards

 

[Michael Gramm]

Can use =IF(A2=$A$5,1,IF(A2=$A$4,2,IF(A2=$A$6,3,IF(A2=$A$9,4,"")))). Don't have to write out descriptions. Just reference the cell with the correct description and and lock it.

 

[sveinhelge.urdal]

or you could use SWITCH
=SWITCH($A2,"Accepted",1,"For information only",2,"Accepted with comments",3,"Not accepted, revise and resubmit",4)
or use =XLOOKUP(A2,$E$2:$E$5,$F$2:$F$5,"",0)

This was really cool. Hov can I make this with the coding on a seperate Tab?