Nested if
 

I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.




--
ab3d4u

Nested if
 

Lots of ways, depending on your actual needs. One:


=IF(A1="a", 1, IF(A1="b", 2, IF(A1="c", 3, 4)))


Another:

=MATCH(A1,{"a","b","c","d"})


In article ,
ab3d4u wrote:

I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.

Nested if
 

=IF(A1=B1,1,if(B1=C1,2,if(C1=D1,3,if(D1=E1,4,5))))

Dave

On Dec 19, 12:29 pm, ab3d4u
wrote:
I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.

--
ab3d4u

Nested if
 

Here is an example of a nested IF:

=IF(A1="A",1,IF(A1="B",2,IF(A1="C",3,IF(A1="D",4,0 ))))

Laura


"ab3d4u" wrote in message
...

I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.




--
ab3d4u

Nested if
 

=CODE(LOWER(A1))-96


"ab3d4u" wrote:


I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.




--
ab3d4u

Nested if
 

Another way..........
=LOOKUP(A1,{0,"a","b","c","d",""},{"",1,2,3,4,""})

Vaya con Dios,
Chuck, CABGx3



"ab3d4u" wrote:


I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.




--
ab3d4u