+ Reply to Thread
Results 1 to 7 of 7

IF Two Conditions Are True Output V1 or P1

  1. #1
    Registered User
    Join Date
    05-28-2015
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    4

    Question IF Two Conditions Are True Output V1 or P1

    Hi, sorry if the title is not descriptive enough.

    I have F7 which is a list with two options "Virtual" and "Physical" I also have F10 which is a list with three options "Base" "Medium" and "Advanced".

    For Cell I5
    Within I5 if F7=Virtual and F10=Base then I need to output "V1". If they do not I need it to stay at 0 (or blank).
    Within I5 if F7=Physical and F10=Base then I need to output "P1". If they do not I need it to stay at 0 (or blank).

    For Cell I7
    Within I7 if F7=Virtual and F10=Medium then I need to output "V1". If they do not I need it to stay at 0 (or blank).
    Within I7 if F7=Physical and F10=Medium then I need to output "P1". If they do not I need it to stay at 0 (or blank).

    For Cell I9
    Within I9 if F7=Virtual and F10=Advanced then I need to output "V1". If they do not I need it to stay at 0 (or blank).
    Within I9 if F7=Physical and F10=Advanced then I need to output "P1". If they do not I need it to stay at 0 (or blank).

    I hope that is clear. I have been playing around with "IF', "AND" and "OR" statements, but can not get it to work.

    Thank you in advance.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,953

    Re: IF Two Conditions Are True Output V1 or P1

    To attach a Workbook
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: IF Two Conditions Are True Output V1 or P1

    Does this work for you?
    Attached Files Attached Files
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: IF Two Conditions Are True Output V1 or P1

    In I5
    =IF(F10="Base",IF(F7="","",LEFT(F7,1)&1),"")

    Change Base to Medium for I7 and Advanced for I9

  5. #5
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: IF Two Conditions Are True Output V1 or P1

    Here's one approach:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  6. #6
    Registered User
    Join Date
    05-28-2015
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    4

    Re: IF Two Conditions Are True Output V1 or P1

    Thank you nigelbloomy, that works perfectly.

    I was half way there, but could not get the "" value, but see where I was going wrong now.

    I will close the thread now.

  7. #7
    Registered User
    Join Date
    05-28-2015
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    4

    Re: IF Two Conditions Are True Output V1 or P1

    Thank you Ron, that also works perfectly.

+ 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. How to add a Rule to output TRUE/FALSE into a column ?
    By zerodegree in forum Excel General
    Replies: 13
    Last Post: 10-25-2014, 12:08 PM
  2. Change from checking if 2 conditions are true to if any of 4 conditions are true
    By tafoyavision in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:17 PM
  3. Replies: 1
    Last Post: 03-26-2014, 02:14 PM
  4. Change default checkbox output true false into text
    By safonso in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 03:31 PM
  5. IF Statement - True Output HELP
    By bighitter43 in forum Excel General
    Replies: 1
    Last Post: 04-07-2008, 11:16 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