+ Reply to Thread
Results 1 to 2 of 2

Help with IFS formula with multiple conditions

  1. #1
    Registered User
    Join Date
    07-22-2008
    Location
    WV
    Posts
    70

    Help with IFS formula with multiple conditions

    I feel like I am on the right tract and it may be something simple such as the wrong number of parentheses, but I have tried many variations of this formula and it doesn’t seem to work.

    =IFS(AND(C11=6,D11=14),38,(AND(C11=6,D11=29),235,TRUE,(ROUND(SUM(D11-4)^2*C11/16-0.01,0)))


    In case I am way off base here and my formula needs clarified, this is what I am trying to achieve:

    If C11=6 and D11=14 then return a value of 38 or if C11=6 and D11=29 then return a value of 235 but if none of those are true then calculate this formula (ROUND(SUM(D11-4)^2*C11/16-0.01,0)

    Any help will be much appreciated. Thanks
    Last edited by jambog; 02-08-2019 at 12:02 PM. Reason: correction

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Help with IFS formula with multiple conditions

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. IF formula with multiple conditions
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-16-2017, 11:16 AM
  2. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  3. Multiple conditions formula
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-30-2015, 03:10 AM
  4. 3 multiple conditions with multiple criteria formula help
    By rmnk101190 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-29-2013, 04:37 PM
  5. [SOLVED] Syntax for formula that uses multiple conditions inside of multiple IF statements
    By njmiller31 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 11:55 AM
  6. Formula With Multiple Conditions
    By andrewc in forum Excel General
    Replies: 3
    Last Post: 12-03-2012, 02:48 PM
  7. [SOLVED] How do I add multiple conditions to a formula?
    By multiple conditions formula in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2006, 03:10 PM

Tags for this Thread

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