I would really appreciate help with the following formula as I just can't get it to work.
For each failure during a month I get charged 10
If I fail three months in a row I get charged and extra 50%, so 15 per failure.
If I fail again in the next month I get an additional 50% on top, so it's now 22.5 per failure.
If I don't fail then it automatically goes back to being charged 10.
3 or more consecutive months of failure incur the 50% premium, increasing by 50% each failure.
<tbody>
</tbody>
I need the formula to be in the total for the year column, totally all months, including any premiums for 3 consecutive failures.
Please help if you , I'm tearing my hair out with this!
For each failure during a month I get charged 10
If I fail three months in a row I get charged and extra 50%, so 15 per failure.
If I fail again in the next month I get an additional 50% on top, so it's now 22.5 per failure.
If I don't fail then it automatically goes back to being charged 10.
3 or more consecutive months of failure incur the 50% premium, increasing by 50% each failure.
Jan | Feb | Mar | ||
Failures | 1 | 2 | ||
<tbody>
</tbody>
I need the formula to be in the total for the year column, totally all months, including any premiums for 3 consecutive failures.
Please help if you , I'm tearing my hair out with this!