Forum Discussion
xPR1MUSx
Oct 17, 2023Copper Contributor
Finding crossing point for positive and negative values
I'm trying to figure out a formula that can determine when a retirement account goes negative (i.e. what age I run out of money) based on a column of monthly values. I have a sheet that shows a s...
- Oct 17, 2023
=INDEX($A$2:$A$13,SMALL(IF(B2:B13<=0,ROW($A$1:$A$12)),1))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
OliverScheurich
Oct 17, 2023Gold Contributor
=INDEX($A$2:$A$13,SMALL(IF(B2:B13<=0,ROW($A$1:$A$12)),1))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
- xPR1MUSxOct 17, 2023Copper ContributorThat is perfect! I've used Index, but not that clever. SMALL is new to me. Thanks so much!