View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default What's wrong with this formula?

On the bottom line you have:

.... + -0.0412415105277979

It looks as if you may be suffering from spurious line-breaks which
occasionally happens with long formulae in the newsgroups and you get
hyphens inserted in the formula. Could be worth checking out wherever
you have minus in the formula.

Hope this helps.

Pete

On Sep 18, 11:11 am, "Alain Sienaert" wrote:
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