Results 1 to 4 of 4

Compare multiple squares

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2011
    Location
    Chernbily Sarkofag
    MS-Off Ver
    Excel 2003
    Posts
    3

    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 !!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1