I have a spreadsheet that consists of a series of four contiguous cells in one row that contain the numbers of 1 through 10 exclusively and without duplication (ie. 10, 1, 5, 9 OR 4, 2, 10, 1). I need a formula that determines whether two specified numbers (ie. 1 AND 5) exist within those four cells. If 'yes' return the number 1, if no return the number "0". This formula will be modified to determine other possibly combinations of numbers (ie. 2 AND 10 or 3 AND 4, etc) on other four cells.