formula help

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I am looking for a formula that will find the break even
age. I have columns as follows:

Age Amount Age Amount
62 100 62 0
63 150 63 0
64 200 64 175
65 250 65 225
66 300 66 290
67 350 67 310
68 400 68 425
69 450 69 575

I would like a formula that will return the age at which
the amounts overlap, or break even (the age at which the
second age/amount set of columns catches up with the first
set.

Thanks
 
Hi Scott
one way: Enter the following array formula (CTRL+SHIFT+ENTER):
=INDEX(A1:A99,MIN(MATCH(TRUE,(D1:D99>=B1:B99),0)))

HTH
Frank
 
-----Original Message-----
Hi Scott
one way: Enter the following array formula (CTRL+SHIFT+ENTER):
=INDEX(A1:A99,MIN(MATCH(TRUE,(D1:D99>=B1:B99),0)))

HTH
Frank



.
Thanks Frank. I tried the formula and am getting a
Click to expand...
#value! result. Maybe this has to do with the fact that
I'm not sure what to do with the ctrl/shift/enter that
preceeded your suggested formula. Is this what I should
do before I enter the =index etc? I tried pressing the
keys and didn't see any difference so I just went ahead
and entered the formula.

Thanks again.
 
Thanks Frank. I tried the formula and am getting a
#value! result. Maybe this has to do with the fact that
I'm not sure what to do with the ctrl/shift/enter that
preceeded your suggested formula. Is this what I should
do before I enter the =index etc? I tried pressing the
keys and didn't see any difference so I just went ahead
and entered the formula.

Thanks again.
Click to expand...

Hi Scott
enter the formula and after that instead of only hitting the ENTER key
hit CTRL+SHIFT+ENTER together. Afterwards the formula should look like
{INDEX(......)}

HTH
Frank
 
-----Original Message-----

Hi Scott
enter the formula and after that instead of only hitting the ENTER key
hit CTRL+SHIFT+ENTER together. Afterwards the formula should look like
{INDEX(......)}

HTH
Frank


.
Ah yes. That did it. Much appreciated. Scott
Click to expand...
 
Back
Top