Below is delemia. I work for a doctors office as a subcontractor- I collect
money from patients. Below is a portion of our spread sheet to be paid.
Right now I have it set up as c44 is my running total collected which veries
month to month. I manually have to place (c44 total) amount into c46
through c49, then I have D46 - d49 figure out the information I manually
placed. figuring out the individual percentages.
What I would like it to do is: - have the c44 distribute the money into the
spots c46 - c49 and if possible have the percentages figured out at the same
time. If not that is ok.
I am not sure how to write the formula. What I need the formula to do is
A B
C D
44 TOTAL REPORT AMT. $8000.00
45
46 BREAKOUT 5000 35% $5000.00 $1750.0
47 $5001 - $7500 30% $2500.00 $750.00
48 $7501 - $10000 28% $ 500.00 $140.00
49 $10000 35% $0.00
50 CONFIRM TOTAL AMT $8000.00
COMMISSION DUE $2640.00