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.
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 !!
Please apply it and check.
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
Please set your condition according to you.