Formula to interpolate between numbers
Using a salary of $245,000, I would like to create a formula that would interpolate the lower and upper percentage range from the below array and give me an output of 72%. What formula do I use?
THANK YOU VERY MUCH!!!!!!
Salary Range Percent Range
$90,000.00 22.00%
$110,000.00 26.00%
$140,000.00 31.00%
$160,000.00 36.00%
$200,000.00 50.00%
$240,000.00 70.00%
$300,000.00 93.00%
$360,000.00 148.00%
$500,000.00 210.00%
$640,000.00 262.00%
Last edited by vlady; 01-06-2014 at 09:38 PM.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks