Needing some help from someone in the know! If I have a series of data - say 4 cells which contain numbers 0-3 and I want to create a formula where I get a result of fail if more than of the cells are 0 or 1. How do I do this?
I basically want a function to tell me if the series has more than 1 cell with a value of 1.
As the values could be any in combination e.g. 2,2,2,1 or 2,1,2,1 or 1,1,2,2 I can’t use a total > formula.