Forum Discussion
Analysis formula based on dates - suggestions
Hi all! I am stumped! I have a large spreadsheet of sales figures by month for a number of years. I want to add in a formula that will calculate sales commissions. The Commissions are payable as f...
Hi Riny, thanks for the prompt reply. So sorry I forgot to say, it needs to be dynamic based on the number of months because i want to be able to drag it forward into future months and we have hundreds to lines to be analysed. so what i was trying to do is write a formula to say count back 12 months from this month (cell AA2) and multiply each 10% and then count back another 12 months from Cell AA2 and multiply each by 1% and add the 2 totals. Do you think thats possible ?
Thanks
Thanks
Reread your question and explanation. Perhaps this one does what you want.
=B3*10%+SUM(C3:N3)*1%