Help w/If Statement
Solved/Closed
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.
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.
Related:
- Help w/If Statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement with text - Guide
- How many if statements can you nest - Guide
- Vba case statement with string - Guide
Feb 22, 2016 at 04:43 PM
Have a good week.