+ Reply to Thread
Results 1 to 4 of 4

If statement that takes results from 2 columns to determine an outcome

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    Springfield, MO
    MS-Off Ver
    2007
    Posts
    42

    If statement that takes results from 2 columns to determine an outcome

    Hello- I am working on a spreadsheet that uses a Data Validation List and a Dependent validation list. In the third column I need an If And Then statement to say If E3="WelcomeBags" And F3="FoldMaps" Then 0.0226 Else blank. I thought this would be the easiest part of the process however it will not work. I either get an error message that says there is something wrong with your formula (but does not give any help as to what) or when I play with the formula I will get a "False".

    The formula I am using is IF(And(E3="WelcomeBags",F3="FoldMaps","0.0226",""))

    I am unsure where I went wrong, from reading other posts the format of the formula seems correct.... Thank you in advance for any assistance!

    JBeets

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: If statement that takes results from 2 columns to determine an outcome

    Try

    =IF(And(E3="WelcomeBags",F3="FoldMaps"),"0.0226","")
    Martin

  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
    53,048

    Re: If statement that takes results from 2 columns to determine an outcome

    If you intend using the 0.0226 in calcs, suggest you remove the "", otherwise excel will consider it text

    =IF(And(E3="WelcomeBags",F3="FoldMaps"),0.0226,"")
    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-17-2014
    Location
    Springfield, MO
    MS-Off Ver
    2007
    Posts
    42

    Re: If statement that takes results from 2 columns to determine an outcome

    Thank you so much! This worked perfectly! So simply!

+ 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. [SOLVED] Multiple outcome if and statement
    By retroboy17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2014, 02:09 AM
  2. [SOLVED] issue with outcome of if/then statement in VBA
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 10:18 AM
  3. If Statement not recognising outcome
    By JoeSharp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2008, 07:18 AM
  4. How to calculate a sum as one outcome of an IF statement
    By barb in NC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2005, 03:06 PM

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