Report

Help w/If Statement [Solved]

Ask a question Cathy - Latest answer on Feb 22, 2016 04:43PM
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.
See more 
Helpful
+0
moins plus
You need what is called a "Nested If" to do this:
=IF(B2<>"",B2,IF(C2<>"",C2,IF(A2<>"",A2,"None")))
Ann- Feb 22, 2016 04:43PM
Thanks so much Ryan. It worked and saved me hours of doing it manually. I had 54k rows. yikes.

Have a good week.
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!