Create a 4x2 table in say M1:N4 of

Amount Payout
0% 25%
97% 100%
101% 200%


and then use

=VLOOKUP(A1,M1:N4,2)

to calculate the payout

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Julie" wrote in message
...
I am trying to compute a payout curve based on the following:

Amount Payout
96% 25%
100% 100%
107% 200%

With those three data points, how do I determine the payouts on all the %
in
between what would a 96.1%, 96.2%, etc payout be?