Results 1 to 7 of 7

'All cells equal' check

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2006
    Posts
    24

    'All cells equal' check

    Hi All,

    Is it possible to write a formula that checks a range of cells all hold the same value?

    i.e. if B1-B10 all = 'True'
    then B11 =True,
    else B11=False

    in the above example I would need all ten cells (b1-B10) with True to return a 'True' response

    I posted a simialr question earlier, but it wasn't very clear.

    Thanks for your time.
    Last edited by steev_jd; 07-05-2010 at 10:59 AM.

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