Help w/If Statement

Solved/Closed
Cathy - Feb 19, 2016 at 05:32 PM
 Ann - Feb 22, 2016 at 04:43 PM
Hello,

Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return the value of column B if data is available, if data is not available, then I want to see if there is data in column C, if there is data in column C then I want to return that value in column D, if there is no data in column C then I want to look for data in column A. If there is data in column A then I want to return that value in column D, if there is no data in column A then column D can return the value of None.

Hope someone can help me w/figuring out the correct formula.

Thank you.

1 response

You need what is called a "Nested If" to do this:
=IF(B2<>"",B2,IF(C2<>"",C2,IF(A2<>"",A2,"None")))
0
Thanks so much Ryan. It worked and saved me hours of doing it manually. I had 54k rows. yikes.

Have a good week.
0