Forum Discussion
Creating a formula that follows specific rules
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.
Do you already have a new Excel version with the functions LET() or even LAMBDA().
I have the function ready, but at the moment it only works with LET().
dscheikey Hi, unfortunately I do not have a newer Excel version. I tested those functions in my excel and they don't prompt anything. 😞
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.
