Hi, is my formula for the “Simple investment calculator” broken? The value does not adjust when I vary the monthly contribution.
Avg total:
=if(and(B11>0,F11>0),INDEX($N11:$BB11,counta($N11:$BB11)),iferror(1/0))
Hi, is my formula for the “Simple investment calculator” broken? The value does not adjust when I vary the monthly contribution.
Avg total:
=if(and(B11>0,F11>0),INDEX($N11:$BB11,counta($N11:$BB11)),iferror(1/0))
duplicate to this thread