Create formula to calculate cumulative fees

May 22, 2011 at 20:42:11
Specs: Windows XP
Percentage Fees are charged monthly on gross sales within an annual tiered system. If annual gross eceeds $2.5m the fee paid drops from 3% to 2.75% and so on to $7m. The fees are paid monthly. We want to track this on a cumulative approach. How do I set the formula up?

See More: Create formula to calculate cumulative fees

Report •

May 24, 2011 at 01:24:41
Your annual cumulative makes the monthly calculation more difficult. I assume there is also a fixed monthly rent plus cam. You will have to carry the gross sale monthly to avoid charging the higher rate,

Report •
Related Solutions

Ask Question