VBA Function that interpolates a value from known percentiles 25th, 50th, 75th and 90th

Hi!

I have a vba function that calculates the percentile of a value when given the 25th, 50th, 75th and 90th percentiles. I would like to manipulate the function so that it performs the opposite, where I input a percentile (ex. 60th percentile) and it calculates the corresponding value using the 25th, 50th, 75th and 90th percentiles. In statistical terms, I believe this is interpolation.

Example:

Given: 25th = $100,000
Given: 50th = $150,000
Given: 75th = $200,000
Given: 90th = $300,000
Input: 60th
Output: 60th = X

Here is the vba function that calculates the percentile. I greatly appreciate any help!

Please Login or Register  to view this content.

Wow that works great! And much simpler! Thank you for the quick response

Ben