+ Reply to Thread
Results 1 to 4 of 4

If statement with BLANKS

  1. #1
    Registered User
    Join Date
    03-23-2015
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    52

    If statement with BLANKS

    Hi All

    Need your help.
    This is how my data looks like....

    A1 B1 C1 D1
    Bob Called Answered Recieved
    Jimmy Answered Called
    LEE Received Answered


    What I need is a column that says
    IF A1 had 3 consecutive "interactions" then say "Multiple" (regardless of what it was,couldve been called, answered or received"

    but also and if statement to show for 2 consecutives "double"
    and also an if statment for 1 "single"

    Any idea? Thanks!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: If statement with BLANKS

    Try

    =LOOKUP(COUNTA($B1:$D1),{1,2,3},{"Single","Double","Triple"})

  3. #3
    Registered User
    Join Date
    03-23-2015
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    52

    Re: If statement with BLANKS

    worked, thanks!!!!!
    Last edited by itshere; 10-19-2017 at 12:06 PM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: If statement with BLANKS

    Worked for me.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF Statement - Accounting for blanks
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2017, 12:58 AM
  2. If statement reading blanks
    By Prince Dakkar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2016, 01:20 PM
  3. IF statement trying to avoid blanks
    By thoron6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2016, 05:39 AM
  4. [SOLVED] IF Statement to check for blanks first
    By drewberts in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2014, 05:06 PM
  5. [SOLVED] If statement with blanks
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 07:14 PM
  6. if statement returning blanks
    By Mayrie in forum Excel General
    Replies: 3
    Last Post: 09-29-2009, 03:59 PM
  7. Replace 0s with blanks - IF statement
    By thomas.szwed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2007, 11:59 AM

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