+ 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
    26

    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
    Excel 2010 on Linux
    Posts
    5,948

    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
    26

    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
    Excel 2010 on Linux
    Posts
    5,948

    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
    26

    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
    Excel 2010 on Linux
    Posts
    5,948

    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
    26

    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)

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