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.
|