ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
For any row in range B1:C11, if there is an amount in both column B and column C, I want to return "Cannot have two amounts on the same row." in cell E1. (Otherwise return "OK").
Here is what is currently in E1, although not working:
{=IF(AND(B1:B11<>"",C1:C11<>""),"Cannot have two amounts on the same row.","OK")}
Can this be done?
Here is what is currently in E1, although not working:
{=IF(AND(B1:B11<>"",C1:C11<>""),"Cannot have two amounts on the same row.","OK")}
Can this be done?