Trying to find out how to do a formula for a spread sheet.
You have 2 bank accounts with the balances below
B1 - $100,000
B2 - $200,000
I want to draw down from B1 a certain amount $X every instance until B1 balance is zero and then start drawing down B2.
The point at which the formula...