Howdy everyone,

I was wondering if there is a command to ask excel to give me the value
$8,990 if % to plan is 100% and compliance falls in 30%

Thanks,

Peter
compliance compliance compliance
% to Plan < 25% 25 - 35 % 35 - 40%
80% $70 $6,990 $698,990
90% $80 $7,990 $798,990
100% $90 $8,990 $898,990
110% $100 $9,990 $998,990
120% $110 $10,990 $1,098,990