Forum Discussion
IF calculation
bclukey wrote: ``the context is debt collection, and no one wants to pay, plus the debtors often don't have much money``
I understand.
But you still do not understand that without additional criteria, the solution is arbitrary. For example, each could pay 1000/3 =333, 333 and 334.
Perhaps you want something like the following:
Enter the amounts into B1 and B2.
But that presumes a "priority" for lower payments. For example, John can pay the least.
Alternatively, If we replace an amount in B2 with a formula of the form =MIN(1000, B1), John would indeed pay the entire amount, unless the amount owed to Richard (B1) exceeds the max that John will pay -- as I wrote previously.
Furthermore, if we replace the formula in B3 with the least of the remainder that James pays (1), Jane will be forced to pay the remainder -- up to her max.
And if we replace the formula in B4 with the least of the remainder that Jane pays (1), the total of the payments might be less than the amount owed (B1), resulting in a nonzero remainder (B5).
bclukey wrote: ``the context is debt collection, and no one wants to pay, plus the debtors often don't have much money``
I understand.
But you still do not understand that without additional criteria, the solution is arbitrary. For example, each could pay 1000/3 =333, 333 and 334.
Perhaps you want something like the following:
Enter the amounts into B1 and B2.
But that presumes a "priority" for lower payments. For example, John can pay the least.
Alternatively, If we replace an amount in B2 with a formula of the form =MIN(1000, B1), John would indeed pay the entire amount, unless the amount owed to Richard (B1) exceeds the max that John will pay -- as I wrote previously.
Furthermore, if we replace the formula in B3 with the least of the remainder that James pays (1), Jane will be forced to pay the remainder -- up to her max.
And if we replace the formula in B4 with the least of the remainder that Jane pays (1), the total of the payments might be less than the amount owed (B1), resulting in a nonzero remainder (B5).
- This is terrific! Thank you!