Forum Discussion

smxyc's avatar
smxyc
Copper Contributor
Sep 26, 2022
Solved

Creating a formula that follows specific rules

Hi, I would like to create a formula to calculate variable earnings.   With $4950 as the basic salary, the variable earnings are:   Less than 25% of target: 0 months of Basic Salary (BS) Less th...
excel
Excel on Mac
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Sep 27, 2022

    smxyc 

    In the attached Excel sheet you will find my formula for interpolating with different slopes. The two ranges for the calculations are entered as aereas or are already stored in curly brackets in the formula. As it is easier for you. I have built a formula without LET(). This should work in any version of Exel.
    Have a look at my file to see if you can do something with it.

     

     

smxyc's avatar
smxyc
Copper Contributor
Sep 27, 2022

dscheikey Hi, unfortunately I do not have a newer Excel version. I tested those functions in my excel and they don't prompt anything. 😞

dscheikey's avatar
dscheikey
Bronze Contributor
Sep 27, 2022

smxyc 

In the attached Excel sheet you will find my formula for interpolating with different slopes. The two ranges for the calculations are entered as aereas or are already stored in curly brackets in the formula. As it is easier for you. I have built a formula without LET(). This should work in any version of Exel.
Have a look at my file to see if you can do something with it.

 

 

Resources