Spreadsheet: 702745d1604509723-creating-formula-to-compute-outstanding-with-tie-to-specific-accounts-saving-vs-expense-1-allenpee85-
Sheet: Sheet1

Expense Account | Expense Acct OS | Saving Account | Saving Acct OS | Expense Account1 | Expense Acct OS1 | Saving Account1 | Saving Acct OS1 | SA Portion to Cover Expense
4000000740 | 0 | 1733039065 | 0
4000247997 | 0 | 1733039065 | 0 |  |  |  |  |  |  |  | Desired Results: For Illustration Purpose
4000247997 | 0 | 3468007124 | 1517154.5 |  |  |  |  |  |  |  | Expense Account | Expense Acct OS | Saving Acct | Saving Acct OS | SA Portion to Cover Expense
4000249717 | 0 | 3468007124 | 1517154.5 |  |  |  |  |  |  |  | 8000359476 | 11600000 | 3468024819 | 9306381.2
4000356297 | 0 | 3468011598 | 6498224.73 |  |  |  |  |  |  |  | 8000357341 | 12000000 | 3468024800 | 18600894.47
4000395771 | 0 | 3468024800 | 18600894.47 |  |  |  |  |  |  |  | 8000357342 | 12000000
4000399720 | 0 | 3468024819 | 9306381.2 |  |  |  |  |  |  |  | 4000000733 | 14557052.68 | WONDA346PG | 374775.75
4000000740 | 0 | AGROSDBH346SG | 0 |  |  |  |  |  |  |  |  |  | WONDA346BA | 66166000
4000247997 | 0 | AGROSDBH346SG | 0 |  |  |  |  |  |  |  | 8000230852 | 24000000 | 3468011598 | 6498224.73
4000000740 | 0 | AGROSDBH346PG | 374775.75 |  |  |  |  |  |  |  |  |  | 3468007124 | 1517154.5
4000247997 | 0 | AGROSDBH346PG | 374775.75 |  |  |  |  |  |  |  | Total
4000000740 | 0 | AGROSDBH346LC | 0
4000247997 | 0 | AGROSDBH346LC | 0
4000000740 | 0 | AGROSDBH346BA | 66166000
4000247997 | 0 | AGROSDBH346BA | 66166000
4000000740 | 0 | AGROSDBH346IL | 0 |  |  |  |  |  |  |  | Expense Account1 | Expense Acct OS | Saving Account1 | Saving Acct OS | Sum of SA Portion to Cover Expense
4000000740 | 0 | AGROSDBH346IL | 0 |  |  |  |  |  |  |  | 4000000733 | 14557052.68 | AGROSDBH346BA | 66166000 | 14182276.93
4000247997 | 0 | AGROSDBH346IL | 0 |  |  |  |  |  |  |  |  |  | AGROSDBH346PG | 374775.75 | 374775.75
4000247997 | 0 | AGROSDBH346IL | 0 |  |  |  |  |  |  |  | 8000230852 | 24000000 | 3468007124 | 1517154.5 | 1517154.5
4000000740 | 0 | AGROSDBH346IB | 0 |  |  |  |  |  |  |  |  |  | 3468011598 | 6498224.73 | 6498224.73
4000000740 | 0 | AGROSDBH346IB | 0 |  |  |  |  |  |  |  | 8000357341 | 12000000 | 3468024800 | 18600894.47 | 12000000
4000247997 | 0 | AGROSDBH346IB | 0 |  |  |  |  |  |  |  | 8000357342 | 12000000 | 3468024800 | 18600894.47 | 6600894.469999999
4000247997 | 0 | AGROSDBH346IB | 0 |  |  |  |  |  |  |  | 8000359476 | 11600000 | 3468024819 | 9306381.2 | 9306381.2
4000000733 | 14557052.68 | 1733039065 | 0 |  |  |  |  |  |  |  | Grand Total |  |  |  | 50479707.58
4000000733 | 14557052.68 | AGROSDBH346LC | 0
4000000733 | 14557052.68 | AGROSDBH346IL | 0
4000000733 | 14557052.68 | AGROSDBH346PG | 374775.75
4000000733 | 14557052.68 | AGROSDBH346BA | 66166000
4000000733 | 14557052.68 | AGROSDBH346SG | 0
4000000733 | 14557052.68 | AGROSDBH346IL | 0
4000000733 | 14557052.68 | AGROSDBH346IB | 0
4000000733 | 14557052.68 | AGROSDBH346IB | 0
8000230852 | 24000000 | 3468011598 | 6498224.73
8000230852 | 24000000 | 3468007124 | 1517154.5
8000230852 | 24000000 | 3468011598 | 6498224.73
8000357341 | 12000000 | 3468024800 | 18600894.47
8000357342 | 12000000 | 3468024800 | 18600894.47
8000359476 | 11600000 | 3468024819 | 9306381.2