What's wrong with your formula is that you have exceeded Excel's limits on
depth of nesting of functions.

I suggest that you look at where you can simplify it.
There are simple things, such as the fact that (B2 +A2 / -(A2)) on the last
line is the same as (B2 -1)
You've got lots of constant terms that could be evaluated separately (in a
separate cell, if you like) and the results included.
cos(sin(cos(cos(exp(sin(Power(exp(4.71 -2.53),2))))))) is one lengthy (and
deeply nested) expression which turns out to be a constant (and which I
struggle to believe can be a physically significant expression), and which
in turn is added to further constant terms.
Other expressions which occur frequently in the formula, such as
Power(sin(exp(Power(sin(ln(2.53)),A2))),0.77)
could again be put in a separate cell & the result called up where
required.

By putting
=Power(sin(exp(Power(sin(ln(2.53)),A2))),0.77) in A3 and
=cos(sin(cos(cos(exp(sin(Power(exp(4.71 -2.53),2))))))) in A4,
the expression simplifies to =
-0.0922863908980922 * ( -(POWER(A3 - A4 -2.6 -2.6 * POWER(LN(3.07
+SIN(4.81)),2) + A3 + A3 *
POWER(EXP(SIN(4.03 -A2)),2),COS(B2 -1)))) + -0.0412415105277979
which does fall within Excel's nesting limit spec

I'd be fascinated if you could tell me what the formula actually does for
you.
--
David Biddulph

"Alain Sienaert" wrote in message
...
Hi,

As the title already suggests we are having problems implementing the
function below.
Have tried it in Excel 2002 and Excel 2003 but always receive an error
("The formula you typed contains an error) when pasting the formula into a
cell.
Pasting the same formula in Mathematica does work and it also works in
Open Office 2.02.


-0.0922863908980922 *
( -(Power(Power(sin(exp(Power(sin(ln(2.53)),A2))),0.7 7) -cos(sin(cos(cos(exp(sin(Power(exp(4.71
-2.53),2))))))) -2.6 -2.6 *Power(ln(3.07 +sin(4.81)),2)
+Power(sin(exp(Power(sin(ln(2.53)),A2))),0.77)
+Power(sin(exp(Power(sin(ln(2.53)),A2))),0.77)
*Power(exp(sin(4.03 -A2)),2),cos(B2 +A2 / -(A2))))) + -0.0412415105277979


Thanks for looking into this annoying problem,
Alain