Forum Discussion
inability to write formula w/ accurate results across 3 cells to compute commissions athigher amts
with respect to the problems with computations that I discussed with you in my post earlier this evening, the more I think about it. Your approach is really very clever.
-It is an approach, i.e. using percentages, if we make it dynamic solves the problems.
-For instance, if the year-over-year amount at $300,000 and the breaking point is $400,000 for the 1st calculation then we would do the calculation for $400,000 find the percentage 300,000 is of $400,000(75%) can take 75% of the commission is available for $400,000 and that would be the figure for the 1st amount up to $400,000 In the 2nd cell the maximum amount that the computation can be is on $200,000 so that if we are $500,000. We know what the computation is for that $200,000 amount and then subtract the amount in the end of year over year from $600,000 and then subtract $400,000 from that figure and find what percentage that is $200,000 and we have that amount. Commission the same thing for the 3rd cell. Now if my reasoning is not all hosed up than this makes the formula dynamic, for whatever amount is in the end of year-over-year initial cell-what are your thoughts. Thanks, Bill Palmer
william palmer try attached file