+ Reply to Thread
Results 1 to 2 of 2

If Statement with Choices

Hybrid View

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    22

    If Statement with Choices

    Thanks in advance for the help.

    A1 = "Flute"
    B1 = "Glue" or "Tape"
    C1 = 10
    D1 = Answer


    I need help with an if statement.

    C1 = 10, add 1/8 if A1 = Flute, if not add 1/4

    At the same time I need to know, AND/OR?

    if B1 = Glue or Tape, then add 3/16 to the overall number

    Tricky part, if A1 does not equal Flute it should be 1/4 added to C1, I would like if B1 = Glue or Tape then add on 5/16 because Flute is not there. Below is better explanation.

    A1: Flute
    B1: Glue
    C1: 10 + 1/8 + 3/16

    A1:
    B1: Glue
    C1: 10 + 1/4 + 5/16

    A1: Flute
    B1:
    C1: 10 + 1/8

    A1: blank or another word
    B1: blank or another word
    C1: 10 + 1/4


    Thanks for the help.
    Kevin

  2. #2
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: If Statement with Choices

    It's not pretty, but try this
    Formula: copy to clipboard
    =IF(AND(A6="Flute",OR(B6="Glue",B6="Tape")),C6+(1/8)+(3/16),IF(AND(A6<>"Flute",OR(B6="Glue",B6="Tape")),C6+(1/4)+(5/16),IF(AND(A6="Flute",OR(B6<>"Glue",B6<>"Tape")),C6+(1/8),C6+(1/4))))
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

+ 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. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  2. % choices
    By DanSD in forum Excel General
    Replies: 2
    Last Post: 07-30-2010, 07:20 PM
  3. choices
    By jhelliar in forum Excel General
    Replies: 3
    Last Post: 03-11-2008, 04:42 PM
  4. [SOLVED] CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
    By pjb in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2006, 04:10 PM
  5. Include several choices in an IF statement.
    By kevin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2005, 08:06 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