I have a cash flow showing the savings account balance, Current account opening balance Etc
I am trying to compute how much cash to transfer either to savings or from savings in G10 based on the following critteria
1) The Minimum bank bank must be 150,000
2) Should the Savings account, be less 50,000 and funds are required to ensure minimum bal of 150,000 must be maintainned, then nothing to be transferred from savings as funds will be transferred from the group HO
Your assistance is most appreciated
Hi Howard,
I created a slightly different layout with some helper columns. It make the formulae easier to follow, I think. See if I understood your question correctly and if you can apply this to your real data.
Hi Riny
This is perfect
Mny thanks for the help
