Nest IF alternative?

[PCLIVE]

This is probably easy, but I don't have a lot of time to think about it
right now. I know you guys will know this.


I'd like to write a formula that in a long format would use nested IF
statements. I'm sure there would be an easier way. What I'd like to do is:

In cell A2:
=IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3)))

Is there an easier way to write this?

Thanks,
Paul

 

[Don Guillett]

Sorry about your lack of time. Of course, we all have a lot of time to do
your work.

 

[Guest]

One way

=IF(OR(A1={"A","B","C"}),A1,A3)


Regards,

Peo Sjoblom

 

[PCLIVE]

If you don't know, then just say so and I'll just give my thanks to PEO.
Apparently you've been doing this a little too long and need to take a
breather.

Thank you anyway for your effort.

Best regards,
Paul

 

[PCLIVE]

Thank you for not taking my words so literal. In no way do I think my time
is more valuable than someone elses. You've been most helpful. Works
Great! I was on the right track, but wouldn't have thought of using the {}.

Thanks again,
Paul

 

[Don Guillett]

I know the answer but didn't like your attitude.