Calculate penalty for absence in this month

Hello everybody,
Could you help me calculate penalty for absence in this month, please?
-This is attendance sheet for employees in 3-2019
-"0" refers to absence
-Penalty for absence can be calculated like this:

No. of days Penalty
1st 1.25
2nd 1.50
3rd 2.00
4th 2.00
5th 2.00
Etc… 2.00

-And this penalty is applied from the beginning of the year(2019),so you should take the other sheet (Whole 2019 absence)into your consideration while calculating
-I recommend using formula but if not possible you can use UDF
-Office 365 proplus
sorry for my bad English

Thank you AliGW for your quick reply,but your formula gives wrong results
I could modify it but it also gives 2 wrong results only,see the attachment:

Please Login or Register  to view this content.

Another example to understand what I want:
If an employee has 3 absence days this month and he doesnot have absence in previous months:
1st day=1.25
2nd day=1.5
3rd day=2
total penalty is 1.25+1.5+2=4.75
I hope you understand me

Is there anything unclear?

No problem AliGW
Happy Easter!

This first attempt uses Ali's approach and generates the desired penalties. The problem is that (unlike Ali's version) the array constants need to be populated for as many elements as your expected maximum possible number of absences for the year and to make matters worse the formula is repeated (with a minor change) twice over. This may become impractical to create/maintain if you expect more than a dozen or so absences.

In AK4 copied down:

Formula:

Please Login or Register  to view this content.

Here is a second attempt that relies on the penalty table that you provided in the March worksheet starting at F3. This approach is probably easier to adapt to a larger max number of absences. The penalty table can be cut/pasted to somewhere else, maybe even on its own worksheet. As with the array constants in the first approach this table will need to be expanded for as many rows as your expected maximum possible number of absences for the year. This approach is essentially the first approach except with a helper table instead of array constants.

In AL4 copied down:

Formula:

Please Login or Register  to view this content.

Maybe there is a simpler approach but you may have to wait for Ali

The attached modified workbook includes both of the above proposed solutions.