View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason M
 
Posts: n/a
Default calculating matrix values

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!!!!