In A1 I have a low or base commission target.
In A2 I have a high or stretch commission target.
In A3 I have a revenue number actually experienced that’s between the low and high.
In A4 I have the total dollars available for commission distribution
In A5 I’m looking for a sliding scale formula that will return a portion of available commission dollars in A4 based on the revenue experience in A3, which will be a number between A1 and A2.

Regards, Gary