+ Reply to Thread
Results 1 to 7 of 7

Formula: IF A has data and E is blank add this text to F...

  1. #1
    Registered User
    Join Date
    01-12-2020
    Location
    So. California
    MS-Off Ver
    360
    Posts
    4

    Question Formula: IF A has data and E is blank add this text to F...

    Occasionally I have to code some projects for a friend I work for.
    Well now, because we are looking to change services, I need to do some heavy coding that is beyond my self taught knowledge.
    So I might be a frequent visitor if that's ok


    Right now I need help with this formula that is located in Column R

    ={ "G2Blank" ; ArrayFormula(IF((AND(A2 <>"", Q2="")), "2. Guest", ""))}


    What I need is for it to check A2 and if it is NOT blank, and Column Q IS blank... then it needs to put the 2. Guest in column R.

    It works for just that row but I need for it to be a A2:A and Q2:Q formula so that it does this for every row as it comes in.... If I add the :A and :Q to the formula it stops working at all.

    What am I doing wrong ... besides try to figure out something I have not been taught .. lol


    Thanks!
    Attached Files Attached Files
    Last edited by AliGW; 01-13-2020 at 01:57 AM. Reason: Irrelevant section of title removed: this is a HELP forum!!!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,018

    Re: Formula Help Needed : IF A has data and E is blank add this text to F...

    Welcome to the forum MrsWWonka.

    This sounds like you will likely benefit by attaching an Excel file upload. Instructions for doing that are at the top of this page (HOW TO ATTACH YOUR SAMPLE WORKBOOK:).
    Dave

  3. #3
    Registered User
    Join Date
    01-12-2020
    Location
    So. California
    MS-Off Ver
    360
    Posts
    4
    Quote Originally Posted by FlameRetired View Post
    Welcome to the forum MrsWWonka.

    This sounds like you will likely benefit by attaching an Excel file upload. Instructions for doing that are at the top of this page (HOW TO ATTACH YOUR SAMPLE WORKBOOK:).
    Thank you!
    Well I tried to post the link to the Google Sheet but it wouldn’t let me. The coding I need is the same as what is used with Excel so I didn’t think it would matter to ask here... not really getting help elsewhere.

  4. #4
    Registered User
    Join Date
    01-12-2020
    Location
    So. California
    MS-Off Ver
    360
    Posts
    4

    Re: Formula Help Needed : IF A has data and E is blank add this text to F...

    I think I attached it correctly now.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,018

    Re: Formula Help Needed : IF A has data and E is blank add this text to F...

    Since this is more a Google sheets question I will move your thread to that sub-forum.

  6. #6
    Registered User
    Join Date
    01-12-2020
    Location
    So. California
    MS-Off Ver
    360
    Posts
    4

    Re: Formula Help Needed : IF A has data and E is blank add this text to F...

    Thank you, I didn't know there was one.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    8,639

    Re: Formula Help Needed : IF A has data and E is blank add this text to F...

    Attempting to open the file attached to post #1 results in the following Microsoft Excel error message on my computer:
    "We found a problem with some content...Do you want us to try and recover as much as we can?"
    Just reading post #1 "so that it does this for every row as it comes in...", it seems that you want R3 to display "2. Guest" if A3 is not blank and Q3 is blank. Is that correct?
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

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