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