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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Failures[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Failures[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!