Your expertise is required to create automated calculation in Excel as per the below explanation. Thank you in advance

[Javs]

Dear Experts,
Kindly help in fixing the below
Lets Say if Net Sale is 1000 Incentive will be 50
Lets Say if Net Sale is 2500 it is in the range of 1001 to 3000 A--->B
and the smaller value before 3000 is 1000 in Vertical B and the difference is 2000 ref condition 2
and the smaller value before 100 is 50 in Vertical Incentive and the difference is 50 ref condition 1
Calculation
CON1/CON2*CON3=Result Result+Smaller Value in Incentive
=50/2000*1500= 37.5 37.5 + 50 = 87.5
The Incentive earned for 2500 is 87.5

 

[Hui]

Javs

Please attach a sample file

 

[Javs]

Javs

Please attach a sample file

Dear Sir,
Here is the attachment. If you need any additional information please let me know.
Thank you.

 

[Javs]

Here is the Excel of the above Image