Richard U
Active Member
- Joined
- Feb 14, 2006
- Messages
- 406
- Office Version
- 365
- 2016
- 2010
- 2007
- Platform
- Windows
Is there a formula to concatenate the results of complex if statements?
I want to concatenate the column header names together if the cells being referenced(two columns) is >0
In other words assuming row 2 is the column headers, something like
I want to concatenate the column header names together if the cells being referenced(two columns) is >0
In other words assuming row 2 is the column headers, something like
Excel Formula:
=(ifB3>0,$B$2, "") & if C3>0, $C&20 "")