capped

  1. S

    Create a dollar value from a range of values that are capped

    Hi All, I am wanting to create a formula that calculates a fee dependent on the value of the sale. Where Cell A1 would be the value of the sale 0 - 29,999.99 Capped $500 30,000 - 49,999.99 2.5% Capped $1,000 50,000 - 99,999.99 1.9% Capped $1,500 100,000 - 149,999.99 1.5% Capped $2,000...
  2. D

    calculating redundancy pay

    does anyone have a formula to help calculate UK redundancy pay rules are as follows: -0.5 weeks pay for each full year under 22 -1 week pay for each full year they were 22 or older but under 41 -1.5 week pay for each full year they were 41 or older -length of service capped at 20 years -weekly...
  3. C

    Advanced formula / function

    Good morning all. I am new to this forum so hope that this makes sense to you! I am trying to work out a commission/bonus model and want Excel to provide me with how much commission we should pay based on certain criteria - which includes a capped amount. We have 2 potential models to work...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top