IF AND Formula

  • Hello All, I am in need of assistance. I have a small table and I need a formula in cell A2 that gives "1" if all cells B3:B8 contain a 1, however I also need it to break down the results if any cell contains a 0. for example if any cell between B3 and B8 contains 0 i need the result in cell A2 to read out A3&B3, A4&B4 etc to ONLY the cells that have a 1. I hope this clear and there are 2 examples in the attached. Thank you.

  • Hi,

    Have you considered simplifying your query and showing only the Header1 that validate your search?

    1. =CONCAT(IF(Table1[Header 2]=1,Table1[Header 1],""))

    Thus giving: