I have to columns
Column H = Department
Column I = Group
Some cells in column H are blank, some cells in column I are blank. I want to test for blanks and:
1. If cell in column H not blank, show contents, else "No Department"
2. If cell in column I not blank, show contents, else "No Group"
3. If both cells in columns H and I blank, show "No Data"
I have written the formulation below, individual parts work but not this combination, ie results column J, Union. Would appreciate any help to understand what I am doing wrong when combine.
=IF(H2="","No Dept",IF(I2="","No Group",IF(H2:I2="","No Data",CONCATENATE(H2,": ",I2))))
Department Group Union
Big Small #VALUE!
Hi Low #VALUE!
Black White #VALUE!
Oil Water #VALUE!
Column H = Department
Column I = Group
Some cells in column H are blank, some cells in column I are blank. I want to test for blanks and:
1. If cell in column H not blank, show contents, else "No Department"
2. If cell in column I not blank, show contents, else "No Group"
3. If both cells in columns H and I blank, show "No Data"
I have written the formulation below, individual parts work but not this combination, ie results column J, Union. Would appreciate any help to understand what I am doing wrong when combine.
=IF(H2="","No Dept",IF(I2="","No Group",IF(H2:I2="","No Data",CONCATENATE(H2,": ",I2))))
Department Group Union
Big Small #VALUE!
Hi Low #VALUE!
Black White #VALUE!
Oil Water #VALUE!