Hello All,


I am a noob in Excel and need help. I am a freelance trainer and need to send pricing based on number of participants. I need a calculator designed which will address the following.

Program A EQ
Cost per candidate 1000
Minimum Candidates 50
Expected Participants 51
Tiered Pricing
Service Tax 12.50%
Total Cost


Minimum Candidates 50: This is a non editable field

Tiered Pricing: This is a entry field which will be blank for the client to enter a number between 51-75. The pricing for the 75th participant will be 800. So a prorata from the 51st participant to the 75th participant should fall within the 200 bracket. So on and so forth.

The tiers are as follow.
1-50: 1000
51-75: 800 (Keeping in mind the distribution of 200 on the number of participants prorate basis)
76-100:600 (Keeping in mind the distribution of 200 on the number of participants prorate basis)
101-150: 400 same as above
151-200: 200

Expected Participants: This is a entry field which will be blank for the client to enter any number
Service Tax: This is fixed.
Total Cost: Sum of Service Tax and Tiered Pricing

Kindly help me address this issue. Will be highly obliged........ Thanks in advance