+ Reply to Thread
Results 1 to 8 of 8

Display true false with IF formula

  1. #1
    Registered User
    Join Date
    10-21-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Display true false with IF formula

    I am trying to get a true/false value from an "IF" formula...
    I think I'm doing something wrong or missing something.

    What I have is - I need cells "C3" and "E3" to have certain values in them so that when they both have the correct value they return a value from "L3" and if either or both of the cells don't have the correct value it returns a "0" value.

    Any help on this would be appreciated.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Display true false with IF formula

    Hello & Welcome to the Forum,

    Something like...

    =IF(AND(C3=5,E3=10),L3,0)
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    10-21-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Display true false with IF formula

    Thanks Jeff,

    Now the big question for you is can I use the same principle to get a False value?
    If "C3" and "L3" have two correct values I get a True, But if "C3" has a different value and "E3" has the correct value I need to be able to get the value from "L3".

    Example: I have "C3" that has a marker in it "I", and "E3" has a month (Jan) in it, I need the value from "L3" to show in "BF3" - But if "C3" has a different marker (not "I") in it and "E3" has the same month (Jan) in it, I need "AS3" to have the value from "L3" in it and the value in "BF3" is False. (Which your previous answer corrected)

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Display true false with IF formula

    Could you post a sample workbook with the different scenarios?

  5. #5
    Registered User
    Join Date
    10-21-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Display true false with IF formula

    Jeff,

    Here is a rough idea of what I'm working with.
    The first set of "Months" is for Expenses, and the second set of "Months" is for Income.

    Thanks,
    Bob
    Attached Files Attached Files

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Display true false with IF formula

    Hi Bob,

    Sorry, last night I was too tired to think straight. It seems this should work for you in AS3...

    =IF(AND(C3<>"I",E3="January"),L3,0)

  7. #7
    Registered User
    Join Date
    10-21-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Display true false with IF formula

    Jeff,

    Thank you sir.
    That did the trick.
    The help is much appreciated.

    Bob

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Display true false with IF formula

    Hi Bob,

    You are very welcome. Glad it works for you and thanks for the feedback

    ---------------------------------------------------------------------------

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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