Multiple If Condition with Percentage

1. 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. Re: Multiple If Condition with Percentage

which one of the conditions should have precedence?

3. 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

4. Re: Multiple If Condition with Percentage

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

5. 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. Re: Multiple If Condition with Percentage

Then remove the *0.6

7. 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

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