+ Reply to Thread
Results 1 to 4 of 4

Help with IFS formula with multiple condition

Hybrid View

  1. 03-02-2021, 09:10 AM #1
    GoldenChicken
    GoldenChicken is offline
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Question Help with IFS formula with multiple condition

    Hello guys, I have a problem here, which hard to explain, so I hope my post will get somehow through you.

    Short explanation, Reorder Qty (PN) is based on Reorder Qty [PLU] of the same Part Number [PN] hence the green highlight. I use SUMIF to do that.

    Part Number (PN) 0002540447 has two duplicate values and 0004309815 has three duplicates values. What I want to do is to fill Reorder Suggested which is the F Column based on Reorder Qty (PN), but it's not that easy. As you can see the formula I use is not perfect, Reorder Suggested for Part Number 0002540447 is -6 and -59 which exceed -59 in total.

    The ideal result I am hoping for is in the G column. I imagine I have to use sumif to do this, but I don't have the capabilities to do that. Anyone can help?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-06-2021, 02:20 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,775

    Re: Help with IFS formula with multiple condition

    Try pasting the following into cell F2 and then dragging the fill handle down to cell F15:
    Formula: copy to clipboard 
    =IF(D2<0,IF(E2>=0,0,MAX(SUM(D2,-SUMIFS(F$1:F1,C$1:C1,C2)),E2)),0)

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 03-26-2021, 03:10 AM #3
    GoldenChicken
    GoldenChicken is offline
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Re: Help with IFS formula with multiple condition

    Thank you so much man
    Reply With QuoteRegister To Reply
  4. 03-26-2021, 09:21 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,775

    Re: Help with IFS formula with multiple condition

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 for Multiple Condition
    By zamal264 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-16-2020, 01:32 PM
  2. Formula with multiple Condition
    By rizmomin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-07-2017, 04:11 PM
  3. [SOLVED] Multiple condition formula
    By JEGERO in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-19-2016, 09:25 AM
  4. [SOLVED] Multiple condition formula?
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-18-2014, 04:31 PM
  5. Multiple condition formula
    By Cjax in forum Excel General
    Replies: 11
    Last Post: 07-28-2009, 10:36 AM
  6. Multiple condition IF formula
    By pcarpilot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2006, 11:07 PM
  7. [SOLVED] Multiple Condition Formula
    By prolixity in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2005, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1