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
|