rdoulaghsingh
Board Regular
- Joined
- Feb 14, 2021
- Messages
- 105
- Office Version
- 365
- Platform
- Windows
I have two cells A1 and B2 which contain the default text<Customer Name>. If either of the two cells (one or the other) contain anything other than "<Customer Name>" I want the text to be displayed in another cell K14.
Below is the excel function I have in K14, but I'm missing something. I tried using the OR operator as well, but that doesn't give me the correct output either. I'm also wondering if there is an additional syntax I can add to the function so if one of the two cells with <Customer Name> gets deleted, it doesn't give an #REF! error. Please help!
=IF(AND(A1<>"<Customer Name>",B1<>"<Customer Name>"), A1, B1)
Below is the excel function I have in K14, but I'm missing something. I tried using the OR operator as well, but that doesn't give me the correct output either. I'm also wondering if there is an additional syntax I can add to the function so if one of the two cells with <Customer Name> gets deleted, it doesn't give an #REF! error. Please help!
=IF(AND(A1<>"<Customer Name>",B1<>"<Customer Name>"), A1, B1)