+ Reply to Thread
Results 1 to 8 of 8

IF Formula (3 arguments from different cells with 2 answers)

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    19

    IF Formula (3 arguments from different cells with 2 answers)

    Good morning

    If someone could please assist with the following, I get the formulas to work each individually. Next set would be to get all of it to work together. I know there is probably a very easy solution to this, as a noob it proves to be difficult.

    N2 should indicate "Open" or "Closed". If M2 has value in it (a date), N2 should display "Open".

    Thereafter when a value is entered into O2 (a date), it should change to "Closed". It will always be in that order, first value into M2, several days later a value (Date) will be entered into O2.

    Last part, M2 may have a date or "info" in cell. When "Info" is entered N2 should also indicate "Closed".

    Thank you in advance for the assistance.
    Last edited by AliGW; 11-06-2018 at 04:19 AM. Reason: Solved tag added.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,385

    Re: IF Formula

    Before we offer help, please improve your thread title as per our forum rules. It needs to be more explicit, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: IF Formula

    Also, To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    07-30-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    19

    Re: IF Formula

    Hi

    Updated, hopefully it complies as per the forum rules.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: IF Formula (3 arguments from different cells with 2 answers)

    Ziro, welkom aan die forum

    Waar omptrent in SA?
    PE old boy here from Klerksdorp, now living in USA.

    maybe something like this?
    N2=if(M2<>"",if(O2="","OPEN","Closed"),"Closed)

  6. #6
    Registered User
    Join Date
    07-30-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    19

    Re: IF Formula (3 arguments from different cells with 2 answers)

    Sup DBibbins

    I am from the Westrand in JHB, currently working on a TOTAL Oil Pipeline Project in Tanzania (Kibirashi at the moment).

    Thanks for this, it is almost there. Although when M2 is empty I'd like N2 not to display any information. Currently showing "Closed" when when M2 is empty. I have included an example.
    Attached Files Attached Files

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: IF Formula (3 arguments from different cells with 2 answers)

    OK, based on what you said above...
    N2=if(M2<>"",if(O2="","OPEN","Closed"),"")

    (did not (yet) open your file

  8. #8
    Registered User
    Join Date
    07-30-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    19

    Re: IF Formula (3 arguments from different cells with 2 answers)

    Perfect, Thank you.

    What is a South African doing in the US?

+ 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. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  2. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  3. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  4. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  5. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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