Results 1 to 5 of 5

IF (possibly OR) Formula assistance - multiple conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    IF (possibly OR) Formula assistance - multiple conditions

    Hello,

    I have made many attempts using a variety of IF, AND, OR combination statements to try and yield the results i'm looking for but have only partially or completely failed so i'm hoping someone can lend me a hand and let me know what i'm missing here.

    I have three basic conditions on the attachment to yield a result in cell B32, they are as follows:

    If B29 = Y, then B32 = $600
    If B29 = N, then B32 = $300
    If B29 = N/A, then B32 = ""

    That part is relatively simple for me to figure out, it's when I add these extra elements that I'm having trouble stacking formulas to get the results I need which are the following:

    If B27 = Exempt, then B32 = ""
    If B27 = NonExempt and If B29 = Y, then B32 = $600 OR If B29 = N, then B32 = $300
    If B27 = Mixed and If B29 = Y, then B32 = $600 OR If B29 = N, then B32 = $300 OR if B31 = B13, B32 = ""

    Not really sure how I can combine all that above into a single formula or if this is wishful thinking

    Thanks ahead of time!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Assistance with CountIF formula and additional formula conditions
    By solios in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2016, 01:46 PM
  2. [SOLVED] VLOOKUP formula with multiple criteria (possibly INDEX/MATCH instead?)
    By Alphabex in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2016, 04:09 AM
  3. Assistance with multiple IF conditions
    By babyjohnson in forum Excel General
    Replies: 3
    Last Post: 08-28-2016, 03:57 AM
  4. [SOLVED] Is there a formula (possibly similar to VLOOKUP) that will return multiple results?
    By SilverUnicorn79 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-16-2016, 04:33 PM
  5. [SOLVED] Array assistance (possibly?)
    By GaidenFocus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-27-2012, 03:08 PM
  6. Replies: 1
    Last Post: 07-16-2012, 12:22 PM
  7. Replies: 2
    Last Post: 04-05-2010, 05:13 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