+ Reply to Thread
Results 1 to 7 of 7

Multiple If Condition with Percentage

  1. #1
    Registered User
    Join Date
    01-07-2018
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    37

    Multiple If Condition with Percentage

    Dear Friends,

    i got stuck on the below If condition not getting how do i get it, in first condition i am exactly getting what i need however need to add one another condition and don't know how do i get it , Can you please review the and suggest

    Formula : =IF(P2=0,K2*60%,J2*P2)

    I need to add new condition in the above formula * If P2 is greater than K2 than L2-K2 * how do i get this please ?

    thanks you

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Multiple If Condition with Percentage

    which one of the conditions should have precedence?

  3. #3
    Registered User
    Join Date
    01-07-2018
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    37

    Re: Multiple If Condition with Percentage

    I am not getting it, i have attached the dummy file.

    now the Formula is in Column Q and i need to extend this as per row 4 and 6 , kindly review
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Multiple If Condition with Percentage

    Try =IF(P2=0,K2*60%,IF(P2>k2,(L2-K2)*0.6,J2*P2))

  5. #5
    Registered User
    Join Date
    01-07-2018
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    37

    Re: Multiple If Condition with Percentage

    thank you i would love to try but before that just wanted to know in 2 condition we only need if P2 >K2 i need L2-K2 only no need to get percentage *0.6

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Multiple If Condition with Percentage

    Then remove the *0.6

  7. #7
    Registered User
    Join Date
    01-07-2018
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    37

    Re: Multiple If Condition with Percentage

    Thank you so much worked perfectly what i needed from this formula however i need one more suggestion i am now getting the answer O or less than 0, if you see column R there is a formula =IFERROR(L2-Q2,0) now in Column R i got the same amount as Column K .

    if you please refer the Row 4 and 6 in the sheet i got -25.22 in cell Q4 and -$46.02 in Cell Q6 i am running one more formula in Column S where it shows underpaid and overpaid , =IF(R2>0,"Overpaid","Underpaid") Can we also add if Column Q has a value O or less than 0 it will shows Underpaid and Overpaid, i am not sure if made you understand please review, thank you so much for your help

+ 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. Separate Percentage condition required
    By Saikrishna12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2018, 11:01 PM
  2. [SOLVED] Multiple Condition Countifs with Uniqueness as Condition
    By semantics in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-21-2017, 05:21 PM
  3. Finding percentage when a condition is met
    By Adamlee in forum Excel General
    Replies: 3
    Last Post: 03-10-2015, 01:05 PM
  4. Condition formatting of multiple condition formatted cells
    By merrin84 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-22-2015, 05:08 PM
  5. Replies: 0
    Last Post: 02-18-2015, 04:45 PM
  6. Replies: 11
    Last Post: 12-30-2012, 01:47 PM
  7. Replies: 6
    Last Post: 05-06-2010, 10:06 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