Calculate the total amount due after the discount in column Total Due. $ $=$ Money. Discount formula is $=$LAMBDA$($StartDate$,$PaymentDate,XLOOKUP$($MAX$(0,$StartDate$-$PaymentDate$),$DiscountT$[$DaysInAdvance$],$DiscountT$[$Discount$],,-1,1))($C$3,$D$3)$ and the formula for the Fee is $=$IFERROR$($LAMBDA$($PlanCode$,$INDEX$($PlanTable$[$Fee$],$XMATCH$($PlanCode$,$PlanTable$[$Code$])))($CustomersT$[$Plan code$]),0)15\%$ $$99\mathrm{.}00$

$0\%$ $$99\mathrm{.}00$

$15\%$ $$50\mathrm{.}00$

$10\%$ $$50\mathrm{.}00$

$15\%$ $$75\mathrm{.}00$

$15\%$ $$50\mathrm{.}00$

$10\%$ $$20\mathrm{.}00$

$0\%$ $$75\mathrm{.}00$

$10\%$ $$99\mathrm{.}00$

$15\%$ $$50\mathrm{.}00$

$0\%$ $ $0\mathrm{.}00$