Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter the 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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter the formula?
=2000/1000000*100134.80
=200,97 -- 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter the formula?
Well is the ratio on a scale or absolute basis?
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter the formula?
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 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) Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
How do I enter formula for < or numbers. | Excel Worksheet Functions | |||
Proper way to enter array formula | Excel Worksheet Functions | |||
Can you enter a formula in a cell to run a macro? | Excel Worksheet Functions |