Kimbers 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?
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,
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.