I tried to put the formula but it doesn’t work. If anyone has a solution, then guide me.

Yes I tried but it only executes the first and second conditions not the third condition.

Hi @CodeOne

Your formula is wrong because the third condition cannot be satisfied !!

base < 9000 is 80

base >= 9000 is 150

the 3rd condition will not be satisfied because of the above 2 !!

Hi @CodeOne,

Please apply it and check.

for example.

```
1800 if (B / total_working_days) * payment_days > 15000 else 900 if 12000 < (B / total_working_days) * payment_days < 15000 else 500 if 9000 < (B / total_working_days) * payment_days < 12000 else 0
```

Reference:

Please set your condition according to you.

Thank You!