Since I was on it while making diner ,
Alternative in same logic
=IF(AND(B9>=$E$6;B9<($E$6+$E$7));N(D8)+1;"")
or adapting Fluff's
=IF(OR(B9<$E$6;B9>$E$6+$E$7-1),"",N(E8)+1)
I will play with this formula. However, to be clear, what I want to do is take a relatively even withdrawal for each of the 10 years. (It is a tax issue.) So, for whichever year the withdrawals start, I want even amounts until the balance is depleted at year 10 (in this case). My dilemma is that for each year, the balance earns interest so I have to account for that as well. THANKS!Not sure I understand completely, but I get you want a countdown, correct?
Try =IF(OR(F9<1,F9>$J$5),0,$J$5-F9)
I will play with this formula. However, to be clear, what I want to do is take a relatively even withdrawal for each of the 10 years. (It is a tax issue.) So, for whichever year the withdrawals start, I want even amounts until the balance is depleted at year 10 (in this case). My dilemma is that for each year, the balance earns interest so I have to account for that as well. THANKS!
Thanks, at least, for taking a look. It has me flummoxed as well. I suppose it is a VBA solution and that's not my skill!Whilst I think I understand whhat you need, I'm afraid I haven't got a clue how to do it.
I did figure it out by looking on the web for TVM calcs and the help of another friend. For future reference here is the solution. Again, thanks!Thanks, at least, for taking a look. It has me flummoxed as well. I suppose it is a VBA solution and that's not my skill!
See my reply to Fluff, below. Again, thanks for the help.Hi Marc, then my formula won't do. As I was afraid, I somewhat misunderstood the point. I think it is more clear now.