Help Please ~ Formulas for Calculating Commission Prices ~ for many entries

[akarr]

Hello .... and THANX in Advance

I'am terrable at excel formula's, I would appreciate and Help here:

Help Please ~ Formulas for Calculating Commission Prices ~ for many entries


Domain Sale Price Commission
$0 - $5,000 20% ( $15 minimum)
$5,001 - $25,000 $1,000 + 15% of amount over $5,000
$25,000 + $4,000 + 10% of amount over $25,000


******

I know it is probably a simple formula to do, but my attempts, do not work correctly,

tried to create ... formula in a single cell ....and can't figure out formula

*********

Again Thanx for any Help on this.

akarr

[Arkadi]

Assuming the sale price is in A4:

=MAX(IF(A4>25000,4000+((A4-25000)*0.1),IF(A4>5000,1000+((A4-5000)*0.15),A4*0.2)),15)

you can just paste this in row 4 of the column you want the comission in and then drag up or down to expand the formula

[Greg M]

Hi there,

Alternatively, if the Sale Price is in Cell B3, use:

=IF(B3 <= 75,  15,  IF(B3 <= 5000,  B3 * 20%,  IF(B3 <= 25000,  1000 + (B3 - 5000) * 15%,   4000 + (B3 - 25000) * 10%)))

Hope this helps - please let me know how you get on.

Regards,

Greg M

[akarr]

Thank You ..... Arkadi & Greg

Great Help .... and Fast Reply ....

It would have taken me WEEEEEks ...of trial & error ....Mostly Error


Both of you Have a Great Week and Great Day

akarr

[Arkadi]

Lol akarr... happy to help
Please remember to mark the thread as solved when you have a moment? Thanks!

[Greg M]

Hi again,

Many thanks for your feedback - glad I was able to help.

Regards,

Greg M