Need help – Mutliple IF conditions

Topic

New Reply

Hi,
I need help on multiple IF conditions for:

I have a salary range of 80-100. If I promote an individual I need to give a minimum of 10% if that takes the individual to 80 or above.

If I give a 15% increase and still does not reach 80 keep it at 15%,

If any increase between 10% to 15% bring this employee to 80. I need get that percentage.

Looking forward to a simple formula for the same.

Regards
Pooja

Reply | Quote

Replies

=IF($A5*(1+HighPercent/100)=LowSalary,LowPercent,(LowSalary-$A5)/$A5*100))

Formula in Col B alongside the old salaries in Col A, HighPercent is 15, LowPercent is 10, LowSalary is 80

Ian.

Reply | Quote

Pooja,

Here is a user defined function. In Cell B2, place the formula =Promotion(A2) then copy down.

HTH,
Maud

36617-Percentages

Code:

Public Function Promotion(rng As Range)
Application.Volatile
For I = 0.1 To 0.15 Step 0.01
    If rng * (I + 1) >= 80000 Then
        Promotion = Format(I, “0.00%”)
        Exit Function
    End If
Next I
Promotion = Format(I, “0.00%”)
End Function

Reply | Quote

OK, so anyone getting 80/(1+0.15)=69.56521739 or less gets 15% and anyone getting 80/(1+0.1)=72.72727273 or more gets 10%. So a formula to calculate the % increase that will ensure these parameters are met for a value in A1 is:
=MAX(MIN((A1*1.15<=80/(1+0.15))*15,(80/A1-1)*100),(A1*1.1<=80/(1+0.15))*10)

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Thank you Ian / Maud / Paul…

Reply | Quote