Hi ,
I'm working on a worksheet that compares early social security payments and full social security payments to find the breakeven point with running totals and dates.
Here's where I'm stuck...
If a value of "1" is in the same row but in column J - then I place the value of ($D$2) in that cell (Column E). (That part works) However, once that row in column E, contains the value of ($D$2), (which I'm finding by using an arbitrary ">100" in my formula) -- , then I need to add that value plus ($D$2) again to each and every consecutive row.
(Each row is a monthly payment that is to be summed down the column) Note: there will be only a single "1" in the entire column J, but at different rows each time.
I tried a couple of things and below is what I tried last.
=IF(AND(J8=1,$D$2,IF(INDIRECT("E"&ROW()-1)>100,(INDIRECT("E"&ROW()-1,+$D$2,"")))))
Thanks - Any assistance would be appreciated
thebrin
Bookmarks