Yes, but we need more information on how your data is set up on the
worksheet. I'm thinking you must have a sheet/table that lists the various
X's, Y's, and the payout percentages. If that is true you could build a
formula that utilizes some lookup functions.

"Jason M" wrote:

I have an incentive matrix with x and y numeric variables (sales goals and
return on sales) and corresponding payout percentages in the data set. Is
there a way to automatically calculate the payout percentage based on the
known payout rates? There are an infinite amount of x and y possible values.

Thanks for any help!!!!