Interpolation

Hi
I need help on attached workbook interpolation. I am trying to calculate "F"
on the base of variable "S" If there are any questions please inform me.


Thanks a lot

Nick

Can you tell us exactly what you're trying to do, so we don't have to guess?

Hi
Thanks for respond, I am trying to calculate F for different categories of A,B,C,D and E, for different values of S, which can varies from 0 to any number. What I attached it works for S if it is 25%,50%,75%,100% and 125%
but it does not work for any other numbers in between those, so I need to be able to find F let us say 30%, or 65%. I hope that I was able to explain, if you have any questions please contact me.

Thanks again

Shantibala

Here's a function you may be able to adapt:

Please Login or Register  to view this content.

And an example:

Please Login or Register  to view this content.

Thanks for your help.
Shantibala