Compare multiple squares

Hi !

I have a problem:

i have asigned 3 numbers, one in each square:

011
000
111
101

and i need a function, that will say, that if the value in the three squares is 111, BINGO, right in the next square, if the value is anthing else: 000,011,101 etc. it will say NO or sth.

ill upload a file so you will have a better understanding of what i am trying to say. (I want the red labels to be a function that will compare the value to 111, and say wether or not is a BINGO or NO)
i tryed with: if, but somehow it shows an error.

Thanks for your help !!

Canon888,

I have attached a modified version of your sample workbook. I replaced the typed "NO"s and "BINGO" with a formula that I copied down.

Hope this helps,
~tigeravatar

Hi

Well, its a little bit complicated, but thanks !!

ive figured you can just use this

=IF(N36&O36&P36="111","JA",0)

the three (N36-->P36) squares contain the 1 or 0s.