Possible Array Solution Needed?
 

So here is my current formula:

=(((((((((((((((((((((((J32-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L
$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10)+I33-J32

J32 is my Ending Balance from the previous year (500,000 in my
example)
I33 is my Withdrawals for the current year (67,000 in my example)
L10 is my Monthly after tax effective rate (0.4% in my example)

The answer should come out to be: ~$22,767

What this formula should be calculating if my "After-tax Interest."
My question is, can anyone help me clean up this formula?

Thanks for your time,

Tyson

Possible Array Solution Needed?
 

This should work:

=FV(L10,12,(I33/12),-J32,1)-J32+I33

" wrote:

So here is my current formula:

=(((((((((((((((((((((((J32-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L
$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10)+I33-J32

J32 is my Ending Balance from the previous year (500,000 in my
example)
I33 is my Withdrawals for the current year (67,000 in my example)
L10 is my Monthly after tax effective rate (0.4% in my example)

The answer should come out to be: ~$22,767

What this formula should be calculating if my "After-tax Interest."
My question is, can anyone help me clean up this formula?

Thanks for your time,

Tyson

Possible Array Solution Needed?
 

Nice! Thanks Tom!

Tyson

On Jul 3, 1:45*pm, TomPl wrote:
This should work:

=FV(L10,12,(I33/12),-J32,1)-J32+I33



" wrote:
So here is my current formula:

=(((((((((((((((((((((((J32-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L
$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-
I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10)+I33-J32

J32 is my Ending Balance from the previous year (500,000 in my
example)
I33 is my Withdrawals for the current year (67,000 in my example)
L10 is my Monthly after tax effective rate (0.4% in my example)

The answer should come out to be: ~$22,767

What this formula should be calculating if my "After-tax Interest."
My question is, can anyone help me clean up this formula?

Thanks for your time,

Tyson- Hide quoted text -

- Show quoted text -