Brian88195
New Member
 Joined
 Mar 24, 2021
 Messages
 2
 Office Version

 365
 Platform

 Windows
Hi, I have searched and tried many samples but couldn’t find any solutions.
I am trying to create a sliding scale calculator for positive and negative premiums earned by a broker. They receive 8% for the first $1,000, 6% for the next $4,000, 4% for the next $95,000 and 2% for everything over $100,000
a policy can have several changes which impact the commission paid. These changes can be positive and negative amounts. I would like to type the amounts in one column and see the amounts go into the buckets listed above and the commission paid for each bucket.
the tricky part is when a negative change occurs. That amount should be subtracted from the previous buckets.
so say if the first amount is $1500, $1000 is in the first bucket and $500 in the second. If a negative $1000 follows it would take $500 from the second bucket first then $500 from the first. If the third amount is a positive $750, $500 would go in the first bucket and $250 in the second.
any suggestions are greatly appreciated. Thanks.
I am trying to create a sliding scale calculator for positive and negative premiums earned by a broker. They receive 8% for the first $1,000, 6% for the next $4,000, 4% for the next $95,000 and 2% for everything over $100,000
a policy can have several changes which impact the commission paid. These changes can be positive and negative amounts. I would like to type the amounts in one column and see the amounts go into the buckets listed above and the commission paid for each bucket.
the tricky part is when a negative change occurs. That amount should be subtracted from the previous buckets.
so say if the first amount is $1500, $1000 is in the first bucket and $500 in the second. If a negative $1000 follows it would take $500 from the second bucket first then $500 from the first. If the third amount is a positive $750, $500 would go in the first bucket and $250 in the second.
any suggestions are greatly appreciated. Thanks.