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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!