formula help
 

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

formula help
 

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

scott wrote:
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

formula help
 

-----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

scott wrote:
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


.
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.

formula help
 

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.

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

formula help
 

-----Original Message-----
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.

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