Need a formula

M

Microsoft

Does any body know a formula that calculates the point where two exponential
lines cross in the future.

Thanks
 
B

Barb Reinhardt

What are the formulas for the two exponential lines?

I'm guessing they intersect where Y1=Y2 and X1=X2.
 
D

Domingos Junqueira

I'm using this formula for calculate de interception

(E3-N3)/((N3*L3)-(E3*(AK3)) 'This is for aritmetical line

E3 and N3 are for initial points
L3 and AK3 are the tax

So I have the initial points and rates and want to calculate the crossing
point.

y=ve^t%d 'this formula calculates de exponential line

Where:
v = value
t% = tax
e = exponential
d = days

I would like to get day first then the number y.

thanks for your atention,

--
Domingos Junqueira

Barb Reinhardt said:
What are the formulas for the two exponential lines?

I'm guessing they intersect where Y1=Y2 and X1=X2.
Click to expand...
 
D

Dana DeLouis

If I'm not mistaken...
With two equations like:

=A1*EXP(B1*d)
=C1*EXP(D1*d)

I think the two cells are equal (with restrictions) when cell named "d"
equals
=(LN(A1/C1))/(D1-B1)

HTH :>)
--
Dana DeLouis
Win XP & Office 2003


Domingos Junqueira said:
I'm using this formula for calculate de interception

(E3-N3)/((N3*L3)-(E3*(AK3)) 'This is for aritmetical line

E3 and N3 are for initial points
L3 and AK3 are the tax

So I have the initial points and rates and want to calculate the crossing
point.

y=ve^t%d 'this formula calculates de exponential line

Where:
v = value
t% = tax
e = exponential
d = days

I would like to get day first then the number y.

thanks for your atention,
Click to expand...
 
Top