I have some spreadsheets that use a ValuePLfunction with an equation like the below
=ValuePL(A1,Tables’!A2:A16,Tables’!B2:B1 6)
The Tables worksheet may look like thebelow:
Calc PS Based ON Power Rating Dif NFL Adj PS -40 -29 -30 -23 -25 -20 -20 -16.5 -15 -13 -10 -9 -5 -4.6 0 0 5 4.6 10 9 15 13 20 16.5 25 20 30 23 40 29
ValuePL is actually a very useful piecewiselinear function that I like better than a lookup table because the result isbasically an extrapolation between two values
I don’t recall if the ValuePL function is aMacro or an excel function but it only works in some of my spreadsheets (Ithink it only works if I open a spreadsheet where it works and then rename it). How can I enable this to work in otherexisting spreadsheets where it does not work.
Right now if I have an existing spreadsheetand want to use ValuePL I need to open a spreadsheet where ValuePL works andrename it and then copy all my worksheets to that new spreadsheet and then itworks.