Calculating Percentages

[Jimh64]

Hello! Thank you in advance for the help!

I am trying to use a calculation where the % used to calculate a number is based on the % entered.

For example:
If the % is below 5% then the multiplier would be zero.
If the % is 5.0% to 5.24% then multiply by 5%
If the % is 5.25% to 5.49% then multiply by 10%
If the % is 5.5% or higher then multiply by 15%

I need to enter in the % and then it will automatically multiply another cell by the correct %. This is for a commission situation.

For example, if sales were $1000 and the % entered in cell was 4.75% then no commission. If sales were $1000 and the % entered was 5.35% then the commission would be $1000 * 10% or $100

Any help is appreciated!

Thanks!

 

[KRice]

I’m happy to help, and thanks for the clarification.