Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for cashflow on every 90th item
hi,
I need a formula which will add together the total number of units (shown monthly) and for every 90th unit put a cost of £250. So, for example: Month 1 2 3 4 5 Units 45 46 15 76 22 Cost £0 £250 £0 £250 £0 How can I do this without it showing £250 in every month??? Thanks Amanda |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for cashflow on every 90th item
On Jun 6, 6:04 pm, Amanda wrote:
hi, I need a formula which will add together the total number of units (shown monthly) and for every 90th unit put a cost of £250. So, for example: Month 1 2 3 4 5 Units 45 46 15 76 22 Cost £0 £250 £0 £250 £0 How can I do this without it showing £250 in every month??? Thanks Amanda Amanda, in your example the 250 cost appears every 60, not every 90 days, i.e. every two months. =SUMPRODUCT(B2:F2+250*(MOD(B1:F1,2)=0)) My formula uses MOD(...,2) for every two months. Change to 3 if you mean every 3 months. HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cashflow | Excel Discussion (Misc queries) | |||
Waterfall cashflow distribution | Excel Discussion (Misc queries) | |||
Annual From Monthly Cashflow | Excel Worksheet Functions | |||
Help: Contingency based fee formula / cashflow analysis | Excel Discussion (Misc queries) | |||
how do I set up cashflow budgets for different projects | New Users to Excel |