Excel Running Total Formula
Hi:
I have a spreadsheet where Marketing dollars are determined from Sales figures. 20% of Sales should be allotted each month toward Marketing, but not to exceed $150,000 for the year. I need the monthly Marketing figures in a row, determined by the running formula based on Sales.
I have attached an example Excel spreadsheet.
Thanks in advance! ExpertsExchange.xls
I have a spreadsheet where Marketing dollars are determined from Sales figures. 20% of Sales should be allotted each month toward Marketing, but not to exceed $150,000 for the year. I need the monthly Marketing figures in a row, determined by the running formula based on Sales.
I have attached an example Excel spreadsheet.
Thanks in advance! ExpertsExchange.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Kevin:
Wow. Great. And quick, too.
One question, however. What if January sales were, for example, $1,000,000 and the Marketing dollars derived from that was $200,000? That would exceed the $150.000 cap....
Thanks.
Wow. Great. And quick, too.
One question, however. What if January sales were, for example, $1,000,000 and the Marketing dollars derived from that was $200,000? That would exceed the $150.000 cap....
Thanks.
See my second post above.
Kevin
Kevin
ASKER
Thanks, Kevin. I posted my followup question before I saw you'd responded with a correction.
Works perfectly. Thanks again!
Works perfectly. Thanks again!
Kevin
ExpertsExchange.xls