I have the following formula:
=IF(ISBLANK(A1),"",IF(OR(A1="a",A1 ="b",A1 = "c",A1 = "d", A1="e", A1="e", A1="f", A1="g", A1="h", A1="i")=TRUE, "PE", "DS"))
but I want to add more arguments to it, so that if A1= "z" the result will also be "PE". However, while this formula works fine as is, if I try to add arguments I get an error that makes me think I've reached the limits allowed. There must be a way! Can anyone help?
Thanks as always,
Lindsay
=IF(ISBLANK(A1),"",IF(OR(A1="a",A1 ="b",A1 = "c",A1 = "d", A1="e", A1="e", A1="f", A1="g", A1="h", A1="i")=TRUE, "PE", "DS"))
but I want to add more arguments to it, so that if A1= "z" the result will also be "PE". However, while this formula works fine as is, if I try to add arguments I get an error that makes me think I've reached the limits allowed. There must be a way! Can anyone help?
Thanks as always,
Lindsay