Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Help w/If Statement [Solved/Closed]

Report
-
 Ann -
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 reply

Answer 1 / 1

You need what is called a "Nested If" to do this: 
=IF(B2<>"",B2,IF(C2<>"",C2,IF(A2<>"",A2,"None")))
Report

Thanks so much Ryan. It worked and saved me hours of doing it manually. I had 54k rows. yikes.

Have a good week.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!