Results 1 to 13 of 13

AND statement with adjacent cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    AND statement with adjacent cells

    In the example attached I am trying to create a statement that will return true with the following conditions: a cell in E:E contains the text “fault 1” and the figure in the cell to the right of that cell is greater than 6.

    So in the attached example cells E1 and F1 would trigger the statement as true as both these conditions are met but if I were to use the same formula for “fault 2” then it would be false as there are no adjacent cells containing a number over 6.

    Hope this makes some sense to anybody?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If statement for adjacent cell
    By kisboros in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2013, 03:59 PM
  2. [SOLVED] Do Loop with If End If statement crashing- looping through column to copy adjacent cell
    By Auwal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 02:33 PM
  3. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  4. IF Statement: Logic Between Adjacent Cells
    By fateshand in forum Excel General
    Replies: 9
    Last Post: 05-29-2009, 11:33 PM
  5. Adjacent cells in non-adjacent list?
    By anakeimai in forum Excel General
    Replies: 3
    Last Post: 09-10-2008, 05:49 PM

Tags for this Thread

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