"B. R.Ramachandran" wrote...
....
My purpose of asking the OP for the functional forms of f(x) and g(x)
was that, if both are linear, logarithmic, simple exponential, quadratic,
or
power functions (and not higher order polynomials), then the x-value (and
from it, the y-value) of the intersection point can be obtained using
analytical formulas. Since those formulas will reference the cells
containing the parameters/constants of f(x) and g(x), the solutions will
automatically (and conveniently) update when f(x) and g(x) change.
....

If the OP's functions are simple low order polynomials, logarithmic or
exponential functions to begin with, it'd be inefficient for the OP to be
fitting trend lines. And the trend lines aren't necessarily good
approximations for the underlying functions near the point of intersection.
Solver is a manual solution (unless the OP were to use a Calculate event
handler to run Solver whenever the function parameters change upon any
recalc), but it's likely to be more accurate than finding the intersection
point of trend line approximations to the underlying functions.