I am making residuals/commission sheet in excel... and the way it works is
that if the total processing volume is 1M... they will receive $2000
commission. So if lets say the processing volume for the month of june is
100,134.80, how much commission will they receive? How do I enter that as a
formula?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"processing volume/commission formula" escreveu:
> I am making residuals/commission sheet in excel... and the way it works is
> that if the total processing volume is 1M... they will receive $2000
> commission. So if lets say the processing volume for the month of june is
> 100,134.80, how much commission will they receive? How do I enter that as a
> formula?
If it's on an absolute basis--the ratio of sales to commissions doesn't
change, regardless of sales level--then calculate the ration of $1million to
$2000 and multiply sales by that ratio to obtain the commission.
A1=$1 million
A2=$2000
A3=$2000/$1million-->your ratio
A4=another sales amount
A5=A3*A4
Dave
--
Brevity is the soul of wit.
"processing volume/commission formula" wrote:
> I am making residuals/commission sheet in excel... and the way it works is
> that if the total processing volume is 1M... they will receive $2000
> commission. So if lets say the processing volume for the month of june is
> 100,134.80, how much commission will they receive? How do I enter that as a
> formula?
> I am making residuals/commission sheet in excel... and the way it works is
> that if the total processing volume is 1M... they will receive $2000
> commission. So if lets say the processing volume for the month of june is
> 100,134.80, how much commission will they receive? How do I enter that as a
> formula?
I am assuming that they will only receive full payments of $2000 for
each 1m volume. If that is correct the formula would be:
=rounddown(A1/1000000,0)*2000
A1 is the cell refereance where your volume would sit (10,013,480)
Question
Reply
Top
Answer
Notify me of replies